Re: Restoring a postgres database - Mailing list pgsql-general

From Dennis Björklund
Subject Re: Restoring a postgres database
Date
Msg-id Pine.LNX.4.44.0307090912550.1516-100000@zigo.dhs.org
Whole thread Raw
In response to Re: Restoring a postgres database  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Restoring a postgres database  (Martijn van Oosterhout <kleptog@svana.org>)
List pgsql-general
On Wed, 9 Jul 2003, Tom Lane wrote:

> > schema dump searching for dependancies. You can then use tsort to dump out
> > the order that things should be restored in.
>
> Now that we have dependency tracking on the server side (see pg_depend)
> this should be just a small matter of programming.  No one's tackled it
> yet though.

It's not enough to just order things. To get something that always works
one need code that can break up cycles in the graph. With alter table and
other constructs it's easy to create objects that depend on each other.

--
/Dennis


pgsql-general by date:

Previous
From: "Maksim Likharev"
Date:
Subject: Re: Statistics on a table
Next
From: mixo
Date:
Subject: Re: Benchmarking