On Wed, May 6, 2009 at 3:37 AM, samana srikanth <samanasrikanth@xxxxxxxxx> 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. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin