From: Tom Lane <tgl@sss.pgh.pa.us>
To: Matt Janssen <matt@luggagepros.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
Date: Mon, 15 Mar 2010 15:58:13 -0400
Message-ID: <22705.1268683093@sss.pgh.pa.us> (raw)
In-Reply-To: <000301cac06e$d54d9f10$7fe8dd30$@com>
References: <000301cac06e$d54d9f10$7fe8dd30$@com>
"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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, matt@luggagepros.com
Subject: Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
In-Reply-To: <22705.1268683093@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox