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