Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 79156632629 for ; Sun, 15 Aug 2010 06:45:29 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 45227-05 for ; Sun, 15 Aug 2010 09:45:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from cronos.madness.at (madness.at [217.196.146.217]) by mail.postgresql.org (Postfix) with ESMTP id 747D9632316 for ; Sun, 15 Aug 2010 06:45:22 -0300 (ADT) Received: from gatekeeper.kaltenbrunner.cc ([83.215.243.9] helo=[192.168.8.22]) by cronos.madness.at with esmtpsa (TLS1.0:DHE_RSA_AES_256_CBC_SHA1:32) (Exim 4.69) (envelope-from ) id 1OkZmE-0001v8-4U; Sun, 15 Aug 2010 11:45:16 +0200 Message-ID: <4C67B729.8010200@kaltenbrunner.cc> Date: Sun, 15 Aug 2010 11:45:13 +0200 From: Stefan Kaltenbrunner User-Agent: Mozilla/5.0 (X11; U; Linux x86_64; en-US; rv:1.9.1.10) Gecko/20100620 Iceowl/1.0b1 Icedove/3.0.5 MIME-Version: 1.0 To: Thom Brown CC: pgsql-docs Subject: Re: pg_dump locking info References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-5 required=5 tests=BAYES_00=-1.9 X-Spam-Level: X-Archive-Number: 201008/35 X-Sequence-Number: 5859 On 08/15/2010 11:01 AM, Thom Brown wrote: > Is this right? I'm looking at > http://www.postgresql.org/docs/current/static/backup-dump.html > > It says, "pg_dump does not block other operations on the database > while it is working. (Exceptions are those operations that need to > operate with an exclusive lock, such as most forms of ALTER TABLE.)" > > So pg_dump actually performs an ALTER TABLE sometimes? :S No it does not - it however blocks operations like ALTER TABLE while it is running(which is exactly how I read the above statement). Stefan