"Matt Janssen" <matt@luggagepros.com> 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