| Author |
Restoring 64 to x86
|
|
| Benjamin Arai 2005-12-26, 1:23 pm |
| Are there any compatability issues from dumping a database from a x86
installation and restoring it on a 64bit install or vice versa? I am
assuming I can go from x86 to 64 but I am not sure about the other way.
Any information would be greatly appreciated.
--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com
| |
| Tom Lane 2005-12-26, 1:23 pm |
| Benjamin Arai <barai@cs.ucr.edu> writes:
> Are there any compatability issues from dumping a database from a x86
> installation and restoring it on a 64bit install or vice versa?
It won't work, in either direction, because of different alignment rules.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
| |
| Benjamin Arai 2005-12-26, 1:23 pm |
| Is there a way to transfer data between the two architectures?
Tom Lane wrote:
>Benjamin Arai <barai@cs.ucr.edu> writes:
>
>
>
>It won't work, in either direction, because of different alignment rules.
>
> regards, tom lane
>
>
--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com
| |
| Joshua D. Drake 2005-12-26, 1:23 pm |
| Benjamin Arai wrote:
> Is there a way to transfer data between the two architectures?
I would think you could do it over the network:
pg_dump -U postgres foo|psql -U postgres -h other_machine foo
>
> Tom Lane wrote:
>
>
> --
> *Benjamin Arai*
> barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
> http://www.benjaminarai.com
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
| |
| Bruce Momjian 2005-12-26, 1:23 pm |
| Benjamin Arai wrote:
> Is there a way to transfer data between the two architectures?
pg_dump.
---------------------------------------------------------------------------
>
> Tom Lane wrote:
>
>
> --
> *Benjamin Arai*
> barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
> http://www.benjaminarai.com
--
Bruce Momjian | http://candle.pha.pa.us
pgman@candle.pha.pa.us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
| |
| Benjamin Arai 2005-12-26, 1:23 pm |
| I thought you said that it would not work in either direction?
Joshua D. Drake wrote:
> Benjamin Arai wrote:
>
>
>
> I would think you could do it over the network:
>
> pg_dump -U postgres foo|psql -U postgres -h other_machine foo
>
>
>
--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com
| |
| Tom Lane 2005-12-26, 1:23 pm |
| Benjamin Arai <barai@cs.ucr.edu> writes:
> Is there a way to transfer data between the two architectures?
Sure: pg_dump. But you can't just move the physical database files,
any more than you could do across completely different architectures.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Benjamin Arai 2005-12-26, 1:23 pm |
| Oh, great. Thanks.
Tom Lane wrote:
>Benjamin Arai <barai@cs.ucr.edu> writes:
>
>
>
>Sure: pg_dump. But you can't just move the physical database files,
>any more than you could do across completely different architectures.
>
> regards, tom lane
>
>
--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com
| |
| Tino Wildenhain 2005-12-26, 8:23 pm |
| Tom Lane schrieb:
> Benjamin Arai <barai@cs.ucr.edu> writes:
>
>
>
> Sure: pg_dump. But you can't just move the physical database files,
> any more than you could do across completely different architectures.
Hehe, x-mas time ;) He said "dumping" and "restoring" on initial post.
I was wondering too as you said it would not work.
Regards
Tino
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
| |
| Tom Lane 2005-12-26, 8:23 pm |
| Tino Wildenhain <tino@wildenhain.de> writes:
> Hehe, x-mas time ;) He said "dumping" and "restoring" on initial post.
> I was wondering too as you said it would not work.
I assumed he was hoping to take a shortcut, but maybe I was overthinking
the question ...
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql
.org so that your
message can get through to the mailing list cleanly
|
|
|
|