Re: Restoring a Full Cluster on a Different Architecture (32 x 64)

From: "Jonah H(dot) Harris" <jonah(dot)harris(at)gmail(dot)com>
To: "Rodrigo Hjort" <rodrigo(dot)hjort(at)gmail(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Date: 2006-03-13 18:36:28
Message-ID: 36e682920603131036n49800b1y43b22598c480e01c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On 3/13/06, Rodrigo Hjort <rodrigo(dot)hjort(at)gmail(dot)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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-03-13 18:37:14 Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Previous Message Merlin Moncure 2006-03-13 18:19:47 Re: Transaction eating up all RAM