| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
| Cc: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: pg_dump question |
| Date: | 2002-01-19 00:59:18 |
| Message-ID: | Pine.LNX.4.33.0201181659100.1800-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-19 01:30:56 | Re: Functions in C with Ornate Data Structures |
| Previous Message | Bruce Momjian | 2002-01-19 00:57:05 | Re: pg_dump question |