| From: | Laurette Cisneros <laurette(at)nextbus(dot)com> |
|---|---|
| To: | <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | pg_dump question |
| Date: | 2002-01-19 00:26:29 |
| Message-ID: | Pine.LNX.4.33.0201181620500.1688-100000@visor.corp.nextbus.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2002-01-19 00:29:43 | Schemas vs. PostQUEL: resolving qualified identifiers |
| Previous Message | Stephen P. Berry | 2002-01-19 00:24:33 | Functions in C with Ornate Data Structures |