Re: DROP TABLE waiting for pg_dump

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Daniel Cristian Cruz" <danielcristian(at)gmail(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: DROP TABLE waiting for pg_dump
Date: 2008-10-02 12:11:45
Message-ID: 23223.1222949505@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Daniel Cristian Cruz" <danielcristian(at)gmail(dot)com> writes:
> I had a problem today, where pg_dump was locking a concurrent DROP TABLE,
> and it was another table, not the table in the COPY running. Is it normal?

Yes. pg_dump acquires ACCESS SHARE lock on all the tables it's
intending to dump. Without that it couldn't guarantee a consistent
dump.

regards, tom lane

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Carol Walter 2008-10-02 17:51:07 Still working on it...
Previous Message Daniel Cristian Cruz 2008-10-02 11:33:44 DROP TABLE waiting for pg_dump