"Matt Janssen" <matt@xxxxxxxxxxxxxxx> writes: > When migrating our Postgres databases from 32 to 64-bit systems, including > large binary objects, how well will this work? > 32-bit server) pg_dump --format=c --blobs --file=backup.pg mydb > 64-bit server) pg_restore -d mydb backup.pg Should be fine; but remember that only gets you the contents of the one database. You may also want pg_dumpall --globals-only to transfer role properties and such. > I'm hoping that PG's compressed custom archive format is not architecture > dependant. Thanks! It is not. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
