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(at)cs(dot)ucr(dot)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(at)cs(dot)ucr(dot)edu <emailto:barai(at)cs(dot)ucr(dot)edu>
>> http://www.benjaminarai.com
>
>

--
*Benjamin Arai*
barai(at)cs(dot)ucr(dot)edu <emailto:barai(at)cs(dot)ucr(dot)edu>
http://www.benjaminarai.com