Re: question about pg_dump -a

From: Vivek Khera <vivek(at)khera(dot)org>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: question about pg_dump -a
Date: 2007-09-28 14:30:50
Message-ID: 8F8AB379-0E8A-406F-B023-63B28FA0AD3C@khera.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


On Sep 28, 2007, at 9:07 AM, Ottavio Campana wrote:

> But why does pg_dump does not already exports data such that previous
> tables do not depend on successive ones?

Because you can't always sort your tables that way. The restore
procedure is responsible for either sorting or disabling the FK
checks during bulk load. The latter is more efficient, especially if
there are no indexes yet, as in a full restore from dump.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John D. Burger 2007-09-28 14:43:21 Re: access privileges: grant select on (all current and future tables)?
Previous Message Vivek Khera 2007-09-28 14:28:47 Re: Debian problem...