pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
От:
"Jack Kerkhof" <jack.kerkhof@guest-tek.com>
Дата:
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
Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
"Jack Kerkhof" writes: > If I run pgdump, and while it is running, execute INSERT, UPDATE, DELETE > commands, what will happen to the pgdump results? Nothing. pg_dump gives a consistent snapshot. > The pgdump documentation is not clear on these transaction concurrency > issues. Yes it is: : pg_dump is a utility for backing up a PostgreSQL database. It makes : consistent backups even if the database is being used concurrently. regards, tom lane