On Thu, Oct 22, 2009 at 3:42 PM, Scot Kreienkamp <SKreien@xxxxxxxxxxxx> wrote:
Hi everyone,
I have a question about pg_dump backups. Will changes made in the database made during a pg_dump operation be reflected in the dumped datafile? Or is the data the exact dataset that was in the database as of the start of the backup?
pg_dump opens transaction, on a serializable isolation level. In short, it is the proper full isolation level (as oppose to the default one: "read committed"). It can cause locks up on database, but the idea is that the dump it self is a snapshot, and is fully atomic.
--
GJ
