Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group