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

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Harry Green <harrygreen91(at)yahoo(dot)com>
Cc: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
Date: 2023-09-18 15:40:50
Message-ID: CAKFQuwacD+6z8cLEPfe+yNOiNj+gy=w-sNN_iFFcG4wqwtBwwA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, Sep 18, 2023 at 8:32 AM Harry Green <harrygreen91(at)yahoo(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Laurenz Albe 2023-09-18 19:28:43 Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order
Previous Message Adrian Klaver 2023-09-18 15:20:06 Re: trouble restoring a database backed up with pg_dump/pg_dump_all - relations are created in the wrong order