We had a similar situation last week, 32-bit to 64-bit OS. We decided to keep
our PostgreSQL 32-bit (our backup/replication servers are still running
32-bit). We are running it on a 64-bit xen image. We used the package manager
to install the 32-bit binaries. Building cross-platform is tricky, s
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
I'm hoping that PG's compressed custom archive format is
