Thread: pg_dump question
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
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
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