Re: Restoring a postgres database

From: Dennis Björklund <db(at)zigo(dot)dhs(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Martijn van Oosterhout <kleptog(at)svana(dot)org>, Timothy Brier <briert(at)cepu(dot)ca>, Andrew Gould <andrewgould(at)yahoo(dot)com>, <pgsql-general(at)postgresql(dot)org>
Subject: Re: Restoring a postgres database
Date: 2003-07-09 07:15:41
Message-ID: Pine.LNX.4.44.0307090912550.1516-100000@zigo.dhs.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message mixo 2003-07-09 07:20:29 Re: Benchmarking
Previous Message Tom Lane 2003-07-09 06:41:04 Re: Restoring a postgres database