Re: pg_dumpall - Mailing list pgsql-general

From Alvaro Herrera
Subject Re: pg_dumpall
Date
Msg-id 20080117184357.GL17828@alvh.no-ip.org
Whole thread Raw
In response to Re: pg_dumpall  (Glyn Astill <glynastill@yahoo.co.uk>)
Responses Re: pg_dumpall
List pgsql-general
Glyn Astill wrote:
> Out of interest, how does pg_dump manage to do a snapshot of a
> database at an instant in time?
>
> My mental picture of pg_dump was just a series of queries dumping out
> the tables...

begin;
set transaction isolation level serializable;

--- begin dumping stuff;



--
Alvaro Herrera                                http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

pgsql-general by date:

Previous
From: Glyn Astill
Date:
Subject: Re: pg_dumpall
Next
From: Tom Lane
Date:
Subject: Re: pg_dumpall