Pg_dump consistency. - Mailing list pgsql-admin

From samana srikanth
Subject Pg_dump consistency.
Date
Msg-id e42828680905060237v62371114v6b474e16e94cf1b3@mail.gmail.com
Whole thread Raw
Responses Re: Pg_dump consistency.
List pgsql-admin
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).

At time 1 (dump of table1 is done)

Table1  
---------
Id1 row1
-----------

Table2  
---------
Id1 rowx1
-----------

At time 2 (dump of table2 is going on)

Table1  
---------
Id1 row1
Id2 row2
-----------

Table2  
---------
Id1 rowx1
Id2 rowx2
-----------


Now in this scenaio
will the dump contains the consistent data.??

Thanks
Srikanth

pgsql-admin by date:

Previous
From: Michael Monnerie
Date:
Subject: Re: Can't drop constraint?
Next
From: Scott Marlowe
Date:
Subject: Re: Pg_dump consistency.