Am Dienstag, 27. Februar 2007 20:37 schrieb Andreas Kretschmer:
> Markus Schulz <[EMAIL PROTECTED]> schrieb:
> > > You can use pg_restore with -l to generate a listfile for all
> > > objects in the database. Then you can reorder this ($EDITOR) and
> > > then use -L to use this ordered listfile to enforce the right
> > > order of objects. I hope this helps you.
> >
> > thanks, nice idea. I will try it.
>
> I have never used this, please tell me if you have success with this.
> (And yes, i hope, i never need this...)
this works.
There is only one general problem with pg_restore, it breaks if there
were errors cause of duplicates. If you have some stuff in your
template and the same in your dump you must solve this manually.
Perhaps there should be an "-ignore-errors" option.
--
Markus Schulz
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
