Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP TABLE waiting for pg_dump - Mailing list pgsql-admin

From Tom Lane
Subject Re: DROP TABLE waiting for pg_dump
Date
Msg-id 23223.1222949505@sss.pgh.pa.us
Whole thread Raw
In response to DROP TABLE waiting for pg_dump  ("Daniel Cristian Cruz" <danielcristian@gmail.com>)
List pgsql-admin
Tree view 
"Daniel Cristian Cruz" <danielcristian@gmail.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

pgsql-admin by date:

Previous
From: "Daniel Cristian Cruz"
Date:
Subject: DROP TABLE waiting for pg_dump
Next
From: Carol Walter
Date:
Subject: Still working on it...