Re: Dump and Reload process - Mailing list pgsql-admin

From Tom Lane
Subject Re: Dump and Reload process
Date
Msg-id 27155.1075527125@sss.pgh.pa.us
Whole thread Raw
In response to Dump and Reload process  (Chris Gamache <cgg007@yahoo.com>)
List pgsql-admin
Chris Gamache <cgg007@yahoo.com> writes:
> I'm having some issues dumping a database from 7.2, reloading it to 7.4.
> I'm using the 7.4 pg_dump. The problem I'm having is an issue of internal
> object dependancies.
> ...
> There must be a better way! Thoughts?

This is (at long last) fixed in development tip.  In existing releases,
the only good solution is to use pg_restore's features for manually
controlling the load order :-(

            regards, tom lane

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Files in pg_xlog
Next
From: "Sally Sally"
Date:
Subject: Separating a single database into different disks