Skip site navigation (1) Skip section navigation (2)

pg_dump locking info

From: Thom Brown <thom(at)linux(dot)com>
To: pgsql-docs <pgsql-docs(at)postgresql(dot)org>
Subject: pg_dump locking info
Date: 2010-08-15 09:01:18
Message-ID: AANLkTi=B3x8MQQvd_xyncArJ9CLPT3cSu8-UjVNZVopr@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-docs
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

-- 
Thom Brown
Registered Linux user: #516935

Responses

pgsql-docs by date

Next:From: Thom BrownDate: 2010-08-15 09:29:39
Subject: Re: pg_dump locking info
Previous:From: Robert HaasDate: 2010-08-15 01:57:43
Subject: Re: pgcrypto links

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group