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 ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
