Re: Restoring 64 to x86

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Benjamin Arai <barai(at)cs(dot)ucr(dot)edu>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)postgresql(dot)org
Subject: Re: Restoring 64 to x86
Date: 2005-12-26 19:01:28
Message-ID: 43B03E08.2020307@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-12-26 19:01:55 Re: Restoring 64 to x86
Previous Message Benjamin Arai 2005-12-26 18:56:28 Re: Restoring 64 to x86