Postgres Pro
Downloads
Home   >   mailing lists

Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order - Mailing list pgsql-general

From David G. Johnston
Subject Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
Date
Msg-id CAKFQuwacD+6z8cLEPfe+yNOiNj+gy=w-sNN_iFFcG4wqwtBwwA@mail.gmail.com
Whole thread Raw
In response to trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order  (Harry Green <harrygreen91@yahoo.com>)
List pgsql-general
Tree view
On Mon, Sep 18, 2023 at 8:32 AM Harry Green <harrygreen91@yahoo.com> wrote: 
Any ideas how I can solve it?

It is most likely you have broken some kind of rule in your database schema, but without seeing the dump file it is impossible to point out what you have done wrong.

Relatedly, the bodies of functions are black-boxes, it is not possible to establish dependencies between them.  This limitation is why many of the rules I allude to above exist.

You have also not mentioned what version you are working with.

David J.

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
Next
From: Laurenz Albe
Date:
Subject: Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order