Re: Postgres Dump out of order - Mailing list pgsql-general

From silly8888
Subject Re: Postgres Dump out of order
Date
Msg-id 3c8f9f940912012341n6278eb26ue236dfbc2f3059d4@mail.gmail.com
Whole thread Raw
In response to Postgres Dump out of order  (Helio Campos Mello de Andrade <helio.campos@gmail.com>)
Responses Re: Postgres Dump out of order  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-general
pg_dump dumps data first and then the constraints (including FK) so
there shouldn't be any problems when you import the dump.



On Wed, Dec 2, 2009 at 2:16 AM, Helio Campos Mello de Andrade
<helio.campos@gmail.com> wrote:
> Hi guys,
>
>  - I'm having a problem when i want to make a backup of my system.
>  - Postgres generated dump was created out of "foreing key" order and when i
> try to recreate my database structures, data and functions. Does someone
> have this same issue? Someone knows of some app that do the job?
>
> Regards...
>
> --
> Helio Campos Mello de Andrade

pgsql-general by date:

Previous
From: Rikard Bosnjakovic
Date:
Subject: Re: Postgres Dump out of order
Next
From: Dave Page
Date:
Subject: Re: Build universal binary on Mac OS X 10.6?