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@svana.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.
signature.asc
Description: Digital signature
