pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / 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>
  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-19 15:20  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Jack Kerkhof <jack.kerkhof@guest-tek.com>
  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