Postgres Pro
Downloads
Home   >   mailing lists

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

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

pgsql-admin by date:

Previous
From: "Vickriz Buenaventuura"
Date:
Subject: Re: pgadmin3 software dependencies?
Next
From: alvaro@audifarma.com.co
Date:
Subject: SOS ---- Could you help me with postgresql.....????