From: Kevin Grittner <Kevin.Grittner@wicourts.gov>
To: Kieren Scott <kierenscott@hotmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pg_dump from 8.4 to 8.3
Date: Mon, 07 Nov 2011 11:16:06 -0600
Message-ID: <4EB7BDF60200002500042B06@gw.wicourts.gov> (raw)
In-Reply-To: <BAY149-W531A2B50F1D7E329A67EE3AED90@phx.gbl>
References: <BAY149-W531A2B50F1D7E329A67EE3AED90@phx.gbl>
Kieren Scott <kierenscott@hotmail.com> wrote:
> I need to migrate some data (a few GB's) from an 8.4 database to
> an 8.3 database using pg_dump. What is the best way to acheive
> this?
This is always a little tricky because you may have objects in your
later-release database which can't be represented in the older
release. My inclination would be to dump with the later release and
hand-modify the file for each error you run into, until you get a
clean restore. Be sure you have an editor which doesn't need to
load the whole file into RAM at one time, if the database is large.
Of course, an even easier route is generally to avoid moving
backward.
-Kevin
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: Kevin.Grittner@wicourts.gov, kierenscott@hotmail.com
Subject: Re: pg_dump from 8.4 to 8.3
In-Reply-To: <4EB7BDF60200002500042B06@gw.wicourts.gov>
* 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