Re: Postgres Dump out of order

From: silly8888 <silly8888(at)gmail(dot)com>
To: Helio Campos Mello de Andrade <helio(dot)campos(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres Dump out of order
Date: 2009-12-02 07:41:33
Message-ID: 3c8f9f940912012341n6278eb26ue236dfbc2f3059d4@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)campos(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Page 2009-12-02 08:46:42 Re: Build universal binary on Mac OS X 10.6?
Previous Message A. Kretschmer 2009-12-02 07:33:19 Re: Postgres Dump out of order