Re: BUG #15253: DROP/select/update query waiting for pg_dump

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: BUG #15253: DROP/select/update query waiting for pg_dump
Дата
Msg-id 20180627150134.lphsddetwachkrkj@alap3.anarazel.de
обсуждение исходный текст
Ответ на BUG #15253: DROP/select/update query waiting for pg_dump  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Hi,

On 2018-06-27 14:01:09 +0000, PG Bug reporting form wrote:
> The following bug has been logged on the website:
> 
> Bug reference:      15253
> Logged by:          NIRBAN SEN
> Email address:      sennirban89@gmail.com
> PostgreSQL version: Unsupported/Unknown
> Operating system:   rhel7
> Description:        
> 
> DROP/select/update queries are going into waiting state when pg_dump is
> running.

DROP TABLE, and many other kinds of DDL, are indeed going to be blocked
by a concurrent pg_dump. That's expected and not a bug.  SELECT / UPDATE
on their own won't.

Please note that the form you used is for reporting a bug, but I do not
see one in your report?

Greetings,

Andres Freund


В списке pgsql-bugs по дате отправления:

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #15253: DROP/select/update query waiting for pg_dump
Следующее
От: Jeff Janes
Дата:
Сообщение: Re: BUG #15253: DROP/select/update query waiting for pg_dump