Re: Pg_dump consistency. - Mailing list pgsql-admin

From Scott Marlowe
Subject Re: Pg_dump consistency.
Date
Msg-id dcc563d10905060248j72b3c57fh49c2ab1bd6564a85@mail.gmail.com
Whole thread Raw
In response to Pg_dump consistency.  (samana srikanth <samanasrikanth@gmail.com>)
List pgsql-admin
On Wed, May 6, 2009 at 3:37 AM, samana srikanth
<samanasrikanth@gmail.com> wrote:
> Hi All
> I have a doubt.
> let's say i have 100 tables in a database DB.
> when i say "pg_dump -d DB"
> It dumps the tables one after another.
> my question is lets say we have dependent tables.
> and at the time of pg_dump, we are bombarding the database tables with lots
> of data (inserts).

pg_dump runs in a serialized transaction, so it will always take a
consistent backup.  This will not be a problem.

pgsql-admin by date:

Previous
From: samana srikanth
Date:
Subject: Pg_dump consistency.
Next
From: Mike Williams
Date:
Subject: pg_standby exit codes