Re: pg_dump question

Laurette Cisneros wrote:
> 
> We use pg_dump nightly to dump data from all tables in our databases (only
> table data, makes restore easier, trust me on that).
> 
> My question is this:
> 
> I have many tables that have millions of rows.
> 
> Let's say I start the pg_dump...
> 
> Then, an update in a transaction occurs that updates 3 different tables
> over a period of time.
> 
> Will some of the pg_dump table data be "out of sync"?
> 
> How exactly does pg_dump (if at all) handle transactions/table changes?

Pg_dump takes a snapshot of the database when it starts to the restore
will be constistent with the start time of pg_dump.  Good question.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026