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

From Tom Lane
Subject Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Date
Msg-id 24309.1079709603@sss.pgh.pa.us
Whole thread Raw
In response to pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?  ("Jack Kerkhof" <jack.kerkhof@guest-tek.com>)
List 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Statistics collecting problem
Next
From: Tom Lane
Date:
Subject: Re: unimplemented functions