Re: Restoring 64 to x86 - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Restoring 64 to x86
Date
Msg-id 43B03E08.2020307@commandprompt.com
Whole thread Raw
In response to Re: Restoring 64 to x86  (Benjamin Arai <barai@cs.ucr.edu>)
Responses Re: Restoring 64 to x86
List pgsql-general
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


pgsql-general by date:

Previous
From: Benjamin Arai
Date:
Subject: Re: Restoring 64 to x86
Next
From: Bruce Momjian
Date:
Subject: Re: Restoring 64 to x86