Re: pg_dump from 8.4 to 8.3

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Kieren Scott" <kierenscott(at)hotmail(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: pg_dump from 8.4 to 8.3
Date: 2011-11-07 17:16:06
Message-ID: 4EB7BDF60200002500042B06@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Kieren Scott <kierenscott(at)hotmail(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Ribe 2011-11-07 17:19:42 Re: streaming replication
Previous Message Kevin Grittner 2011-11-07 17:10:03 Re: streaming replication