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.