Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Jack Kerkhof" <jack(dot)kerkhof(at)guest-tek(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Date: 2004-03-19 15:20:03
Message-ID: 24309.1079709603@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Jack Kerkhof" <jack(dot)kerkhof(at)guest-tek(dot)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

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2004-03-19 15:25:52 Re: create function problem
Previous Message Tom Lane 2004-03-19 14:49:10 Re: Statistics collecting problem