From: Matt Janssen <matt@luggagepros.com>
To: pgsql-admin@postgresql.org
Subject: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
Date: Wed, 10 Mar 2010 10:29:18 -0600
Message-ID: <000301cac06e$d54d9f10$7fe8dd30$@com> (raw)
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!
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: matt@luggagepros.com
Subject: Re: pg_dump / pg_restore with Large Objects from 32-bit to 64-bit
In-Reply-To: <000301cac06e$d54d9f10$7fe8dd30$@com>
* 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