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

From Greg Stark
Subject Re: Restoring a Full Cluster on a Different Architecture (32 x 64)
Date
Msg-id 87wteyjhun.fsf@stark.xeocode.com
Whole thread Raw
In response to Restoring a Full Cluster on a Different Architecture (32 x 64)  ("Rodrigo Hjort" <rodrigo.hjort@gmail.com>)
List pgsql-hackers
"Rodrigo Hjort" <rodrigo.hjort@gmail.com> writes:

> 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?

Unfortunately pg_dump/pg_restore is going to be your only option here. The
database files are specific to the architecture and 32-bit and 64-bit linux
are different architectures. It's just as hard as moving from Sparc to IA32.
The only mechanism Postgres has it to do a dump and restore.

-- 
greg



pgsql-hackers by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: [PERFORM] Hanging queries on dual CPU windows
Next
From: Bernd Helmle
Date:
Subject: Re: Proposal for updatable views