Re: BUG #15253: DROP/select/update query waiting for pg_dump - Mailing list pgsql-bugs

From Andres Freund
Subject Re: BUG #15253: DROP/select/update query waiting for pg_dump
Date
Msg-id 20180627150134.lphsddetwachkrkj@alap3.anarazel.de
Whole thread Raw
In response to BUG #15253: DROP/select/update query waiting for pg_dump  (PG Bug reporting form <noreply@postgresql.org>)
List 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 by date:

Previous
From: PG Bug reporting form
Date:
Subject: BUG #15253: DROP/select/update query waiting for pg_dump
Next
From: Jeff Janes
Date:
Subject: Re: BUG #15253: DROP/select/update query waiting for pg_dump