Postgres Pro
Downloads
Home   >   mailing lists

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

From Jeff Janes
Subject Re: BUG #15253: DROP/select/update query waiting for pg_dump
Date
Msg-id CAMkU=1yQfwuTdGMBYhBWrVAdonN9Dg-TuRfD6Mh4KHbp3BCj3A@mail.gmail.com
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
Tree view
On Wed, Jun 27, 2018 at 10:01 AM, PG Bug reporting form <noreply@postgresql.org> 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.

I'm using 9.2.18 version.


That's not a bug.  Selects and Updates alone should not block on a pg_dump, but in conjunction with DROP they certainly can.  You can't DROP a table while it is being dumped, and you can't select from a table while it is waiting to be dropped.

Cheers,

Jeff

pgsql-bugs by date:

Previous
From: Andres Freund
Date:
Subject: Re: BUG #15253: DROP/select/update query waiting for pg_dump
Next
From: PG Bug reporting form
Date:
Subject: BUG #15254: The configure --with-zlib option ignores zlib customlocation