Re: [GENERAL] Restoring a postgres database

2003-07-08 Thread Tom Lane
Martijn van Oosterhout <[EMAIL PROTECTED]> 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 tha

Re: [GENERAL] Restoring a postgres database

2003-07-08 Thread Martijn van Oosterhout
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. Has anyone attempted this

Re: [GENERAL] Restoring a postgres database

2003-07-08 Thread Timothy Brier
Andrew Gould wrote: --- Timothy Brier <[EMAIL PROTECTED]> wrote: Hi, I've run in to this problem with a database we are working. When I restore a database schema, I need to restore the schema 5 times to ensure that the schema is complete. Also some of the sequences are not restored in a usab

Re: [GENERAL] Restoring a postgres database

2003-07-08 Thread Andrew Gould
--- Timothy Brier <[EMAIL PROTECTED]> wrote: > Hi, > > I've run in to this problem with a database we are > working. When I > restore a database schema, I need to restore the > schema 5 times to > ensure that the schema is complete. Also some of > the sequences are not > restored in a usable

[GENERAL] Restoring a postgres database

2003-07-08 Thread Timothy Brier
Hi, I've run in to this problem with a database we are working. When I restore a database schema, I need to restore the schema 5 times to ensure that the schema is complete. Also some of the sequences are not restored in a usable form. E.g. If my next sequence should be 1000, my sequence is