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
pgsql-admin by date
|Next:||From: Louie Kwan||Date: 2004-03-17 21:45:00|
|Subject: Re-Init database cluster.|
|Previous:||From: Tom Lane||Date: 2004-03-17 16:53:36|
|Subject: Re: Row data corruption under 7.3.5 |