pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? 2+ messages / 2 participants [nested] [flat]
* pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? @ 2004-03-17 19:29 Jack Kerkhof <jack.kerkhof@guest-tek.com> 2004-03-19 15:20 ` Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 1 reply; 2+ messages in thread From: Jack Kerkhof @ 2004-03-17 19:29 UTC (permalink / raw) To: 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? 2004-03-17 19:29 pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? Jack Kerkhof <jack.kerkhof@guest-tek.com> @ 2004-03-19 15:20 ` Tom Lane <tgl@sss.pgh.pa.us> 0 siblings, 0 replies; 2+ messages in thread From: Tom Lane @ 2004-03-19 15:20 UTC (permalink / raw) To: Jack Kerkhof <jack.kerkhof@guest-tek.com>; +Cc: pgsql-admin "Jack Kerkhof" <jack.kerkhof@guest-tek.com> 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2004-03-19 15:20 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2004-03-17 19:29 pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? Jack Kerkhof <jack.kerkhof@guest-tek.com> 2004-03-19 15:20 ` Tom Lane <tgl@sss.pgh.pa.us>
This inbox is served by DDX for PostgreSQL; see mirroring instructions for how to clone and mirror all data and code used for this inbox