Re: problems restoring 7.2.1 dump to 7.3.2 - Mailing list pgsql-general

From Martijn van Oosterhout
Subject Re: problems restoring 7.2.1 dump to 7.3.2
Date
Msg-id 20030505093433.GB10382@svana.org
Whole thread Raw
In response to Re: problems restoring 7.2.1 dump to 7.3.2  (Ralph Graulich <maillist@shauny.de>)
List pgsql-general
On Mon, May 05, 2003 at 11:05:41AM +0200, Ralph Graulich wrote:
> It took me a whole three days to rearrange about nearly 1.400 database
> objects, couting sequences, triggers, tables, views, rules and pl/pgsql
> procedures. So, one thing I learned: Before extending my project, first
> accomplish a working upgrade path by writing down all dependencies ;-)

I wonder if it would be possible to create script that would take a guess at
all the dependancies, feed that to tsort and somehow get pg_restore to
restore the DB in the right order.

--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> "the West won the world not by the superiority of its ideas or values or
> religion but rather by its superiority in applying organized violence.
> Westerners often forget this fact, non-Westerners never do."
>   - Samuel P. Huntington

Attachment

pgsql-general by date:

Previous
From: Martijn van Oosterhout
Date:
Subject: Re: Postgres Java Connection not closing.. Too many Clients Problem
Next
From: "Nigel J. Andrews"
Date:
Subject: Re: Database server restarting