| From: | Alvaro Herrera <alvherre(at)commandprompt(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | Steve Clark <sclark(at)netwolves(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: pg_dumpall |
| Date: | 2008-01-17 18:36:10 |
| Message-ID: | 20080117183610.GK17828@alvh.no-ip.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Tom Lane wrote:
> Steve Clark <sclark(at)netwolves(dot)com> writes:
> > does pg_dumpall make consistent backups if the database is being used
> > concurrently?
> > Even though the man page doesn't say it does.
>
> That's intentional, because it doesn't. What you get is a pg_dump
> snapshot of each database in sequence; those snapshots don't all
> correspond to the same time instant. There isn't any good way to
> guarantee time coherence of dumps across two databases.
The fine point possibly being missed is that each database's dump
produced by pg_dumpall is, of course, self-consistent.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Glyn Astill | 2008-01-17 18:37:25 | Re: pg_dumpall |
| Previous Message | Tom Lane | 2008-01-17 18:19:37 | Re: pg_dumpall |