From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
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:37:14 |
Message-ID: | 20060313183714.GJ6714@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
On Mon, Mar 13, 2006 at 02:56:00PM -0300, Rodrigo Hjort wrote:
> Dear PostgreSQL Hackers,
>
> We got a PG 8.1 on a Debian 64 bits, which does a full backup (PITR) daily.
> Then we installed a Debian 32 bits (actually, it's on VMWare) and wanted to
> restore the previous PG cluster on it.
> As there are a lot of indexes, specially GiST, "pg_dump" and "pg_restore"
> are not viable - will take a lot of time!
Can't be done. The differences in alignments, size, placement, etc will
make it completly. PostgreSQL doesn't even try to maintain a consistant
file format with different configure options...
pg_dump is the only way.
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Patent. n. Genius is 5% inspiration and 95% perspiration. A patent is a
> tool for doing 5% of the work and then sitting around waiting for someone
> else to do the other 95% so you can sue them.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2006-03-13 18:44:59 | Re: Transaction eating up all RAM |
Previous Message | Jonah H. Harris | 2006-03-13 18:36:28 | Re: Restoring a Full Cluster on a Different Architecture (32 x 64) |