Re: Restoring 64 to x86

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