Re: Restoring a postgres database

Martijn van Oosterhout <kleptog@svana.org> writes:
> I've been reading about these problems (but never experienced myself). I've
> always wondered if it would be possible to write a script to scan through a
> 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.

            regards, tom lane