Re: [ADMIN] pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

2010-03-15 Thread Tom Lane
"Matt Janssen" 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 o

[ADMIN] pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

2010-03-15 Thread Matt Janssen
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