X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 96F71D1B4BC for ; Fri, 19 Mar 2004 15:20:10 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 38409-09 for ; Fri, 19 Mar 2004 11:20:06 -0400 (AST) Received: from sss.pgh.pa.us (unknown [192.204.191.242]) by svr1.postgresql.org (Postfix) with ESMTP id C83EAD1BB74 for ; Fri, 19 Mar 2004 11:20:01 -0400 (AST) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i2JFK34h024310; Fri, 19 Mar 2004 10:20:04 -0500 (EST) To: "Jack Kerkhof" Cc: pgsql-admin@postgresql.org Subject: Re: pgdump - What happens to data modifications (INSERT, UPDATE, DELETE) while pgdump is running? In-reply-to: References: Comments: In-reply-to "Jack Kerkhof" message dated "Wed, 17 Mar 2004 12:29:56 -0700" Date: Fri, 19 Mar 2004 10:20:03 -0500 Message-ID: <24309.1079709603@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200403/260 X-Sequence-Number: 12829 "Jack Kerkhof" writes: > If I run pgdump, and while it is running, execute INSERT, UPDATE, DELETE > commands, what will happen to the pgdump results? Nothing. pg_dump gives a consistent snapshot. > The pgdump documentation is not clear on these transaction concurrency > issues. Yes it is: : pg_dump is a utility for backing up a PostgreSQL database. It makes : consistent backups even if the database is being used concurrently. regards, tom lane