Re: Restoring 64 to x86

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