
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?

Thanks for the info.

-- 
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere


Fri, 18 Jan 2002 16:26:29 -0800 (PST)
Laurette Cisneros <laurette@nextbus.com>
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, Pennsylvania 19026

Fri, 18 Jan 2002 19:57:05 -0500 (EST)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: pg_dump question
This is most execellent!

On Fri, 18 Jan 2002, Bruce Momjian wrote:

> 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.
>
>

-- 
Laurette Cisneros
(510) 420-3137
NextBus Information Systems, Inc.
www.nextbus.com
Passenger Information Everywhere


Fri, 18 Jan 2002 16:59:18 -0800 (PST)
Laurette Cisneros <laurette@nextbus.com>
Re: pg_dump question