Thread: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit

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

From
"Matt Janssen"
Date:

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 not architecture dependant. Thanks!

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

From
Tom Lane
Date:
"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