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

From: Greg Stark <gsstark(at)mit(dot)edu>
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:54:24
Message-ID: 87wteyjhun.fsf@stark.xeocode.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


"Rodrigo Hjort" <rodrigo(dot)hjort(at)gmail(dot)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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bernd Helmle 2006-03-13 19:01:56 Re: Proposal for updatable views
Previous Message Merlin Moncure 2006-03-13 18:49:45 Re: [PERFORM] Hanging queries on dual CPU windows