Restoring 64 to x86

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

Is there a way to transfer data between the two architectures?

Tom Lane wrote:

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

--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com

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

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> 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

--
*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

I thought you said that it would not work in either direction?

Joshua D. Drake wrote:

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> 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

--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com

--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com

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

Oh, great. Thanks.

Tom Lane wrote:

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

--
*Benjamin Arai*
barai@cs.ucr.edu <emailto:barai@cs.ucr.edu>
http://www.benjaminarai.com

Tom Lane schrieb:

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.

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

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