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

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

From: "Jack Kerkhof" <jack(dot)kerkhof(at)guest-tek(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running?
Date: 2004-03-17 19:29:56
Message-ID: ENEIKKAEJOFHOIHMMOIDAEINEDAA.jack.kerkhof@guest-tek.com (view raw or flat)
Thread:
Lists: 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




Responses

pgsql-admin by date

Next:From: Louie KwanDate: 2004-03-17 21:45:00
Subject: Re-Init database cluster.
Previous:From: Tom LaneDate: 2004-03-17 16:53:36
Subject: Re: Row data corruption under 7.3.5

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