Re: DROP TABLE waiting for pg_dump

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: DROP TABLE waiting for pg_dump
Дата
Msg-id 23223.1222949505@sss.pgh.pa.us
обсуждение исходный текст
Ответ на DROP TABLE waiting for pg_dump  ("Daniel Cristian Cruz" <danielcristian@gmail.com>)
Список pgsql-admin
"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 по дате отправления:

Предыдущее
От: "Daniel Cristian Cruz"
Дата:
Сообщение: DROP TABLE waiting for pg_dump
Следующее
От: Carol Walter
Дата:
Сообщение: Still working on it...