Postgres Pro
Downloads
Home   >   mailing lists

Re: Restoring a Full Cluster on a Different Architecture (32 x 64) - Mailing list pgsql-hackers

From Jonah H. Harris
Subject Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Date
Msg-id 36e682920603131036n49800b1y43b22598c480e01c@mail.gmail.com
Whole thread Raw
In response to Restoring a Full Cluster on a Different Architecture (32 x 64)  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
Responses Re: Restoring a Full Cluster on a Different Architecture (32 x 64)  ("Jim C. Nasby" <jnasby@pervasive.com>)
List pgsql-hackers
Tree view
On 3/13/06, Rodrigo Hjort <rodrigo.hjort@gmail.com> wrote:
As the architecture on both Linuxes are different (32 and 64 bits), I think "PGDATA/global/pg_control" might contains 64 bit data such that the 32 bits binary won't recognize or even mispell it. Am I right?

Yes, the platform architecture is key.  You won't be able to read the 64-bit data files on a 32-bit box.

What could be done in order to fix it? Is there any kind of application to translate it or the only solution was to "pg_dumpall" and "pg_restore" the cluster?

Yes, dump and restore is the best way to go.


--
Jonah H. Harris, Database Internals Architect
EnterpriseDB Corporation
732.331.1324

pgsql-hackers by date:

Previous
From: "Rodrigo Hjort"
Date:
Subject: Restoring a Full Cluster on a Different Architecture (32 x 64)
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Restoring a Full Cluster on a Different Architecture (32 x 64)