Re: pg_dumpall

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Steve Clark <sclark(at)netwolves(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: pg_dumpall
Date: 2008-01-17 18:19:37
Message-ID: 11205.1200593977@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

regards, tom lane

In response to

  • pg_dumpall at 2008-01-17 17:53:14 from Steve Clark

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2008-01-17 18:36:10 Re: pg_dumpall
Previous Message Alvaro Herrera 2008-01-17 18:00:55 testing the news gateway