pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?

From: "Jack Kerkhof" <jack(dot)kerkhof(at)guest-tek(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Date: 2004-03-17 19:29:56
Message-ID: ENEIKKAEJOFHOIHMMOIDAEINEDAA.jack.kerkhof@guest-tek.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

If I run pgdump, and while it is running, execute INSERT, UPDATE, DELETE
commands, what will happen to the pgdump results?

- Is pgdump all contained in a single transaction, so it just gets the
'before' data state,
- Do some of the modifications end up in the dump, but not others depending
upon where the
dump is at that exact moment?

The pgdump documentation is not clear on these transaction concurrency
issues.

Thanks, Jack

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Louie Kwan 2004-03-17 21:45:00 Re-Init database cluster.
Previous Message Tom Lane 2004-03-17 16:53:36 Re: Row data corruption under 7.3.5