X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 1D1379DC86A for ; Mon, 9 Jan 2006 13:29:04 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 25341-03 for ; Mon, 9 Jan 2006 13:29:03 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.204]) by postgresql.org (Postfix) with ESMTP id DA4169DC835 for ; Mon, 9 Jan 2006 13:29:01 -0400 (AST) Received: by wproxy.gmail.com with SMTP id i28so2676612wra for ; Mon, 09 Jan 2006 09:29:01 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=azLeHqtlkCyUFyVQMOqtxyQIa92nsriKWDkSt1Ksy6wap+BRtR5HD1V18a0Z45+GBh2GegAHAlV4ZMXi63qurpV+gwy9+Yd/8W92uclUrasl7h1uE0AgHc0I08j058BDSqNF4DlhLl4356E1YXtkh5DYoGdP+f36mAPYMiUdxbM= Received: by 10.54.115.14 with SMTP id n14mr5096358wrc; Mon, 09 Jan 2006 09:29:00 -0800 (PST) Received: by 10.54.92.14 with HTTP; Mon, 9 Jan 2006 09:29:00 -0800 (PST) Message-ID: Date: Mon, 9 Jan 2006 12:29:00 -0500 From: Jaime Casanova To: Chris Hoover Subject: Re: What happens to transactions durring a pg_dump? Cc: "pgsql-admin@postgresql.org" In-Reply-To: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com> MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1d219a6f0601090922s5224e78emd68cf850b836c2af@mail.gmail.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.082 required=5 tests=[AWL=0.082] X-Spam-Score: 0.082 X-Spam-Level: X-Archive-Number: 200601/92 X-Sequence-Number: 20180 On 1/9/06, Chris Hoover wrote: > I'm trying to understand better what happens to a transaction that is > commited in the middle of a pg_dump. Is the transaction included in the > database dump, or is it excluded. > AFAIK, it's excluded... -- regards, Jaime Casanova (DBA: DataBase Aniquilator ;)