Re: pg_restore problem

Lonni J Friedman <lfriedman@vasoftware.com> writes:
> pg_restore: [archiver (db)] could not execute query: ERROR:  Relation
> "artifact_file" does not exist

> My guess is that the problem is that artifact_file has not yet been
> restored from the dump (its further along), however I don't understand how
> to compensate for this problem.

You need to force pg_restore to load the database objects in a safe
order.  I haven't done this recently, but basically you make a listing
of the archive's table of contents (TOC), rearrange it with a text
editor, and use that file as a control file for pg_restore.  See the
pg_restore man page.

Eventually this should be automated better :-(

            regards, tom lane