Re: [PATCH] Fix drop replication slot blocking instead of returning error
Craig Ringer <craig@2ndquadrant.com>
From: Craig Ringer <craig@2ndquadrant.com>
To: Andres Freund <andres@anarazel.de>
Cc: Simone Gotti <simone.gotti@gmail.com>,
Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2017-08-30T00:36:00Z
Lists: pgsql-hackers
On 29 August 2017 at 22:02, Andres Freund <andres@anarazel.de> wrote: > Hi, > > On 2017-08-29 13:42:05 +0200, Simone Gotti wrote: > > On Tue, Aug 29, 2017 at 12:13 PM, Alvaro Herrera > > <alvherre@2ndquadrant.com> wrote: > > > > > > > Hi Alvaro, > > > > > Simone Gotti wrote: > > > > Hi all, > > > > > > > > I noticed that in postgres 10beta3, calling pg_drop_replication_slot > on an > > > > active slot will block until it's released instead of returning an > error > > > > like > > > > done in pg 9.6. Since this is a change in the previous behavior and > the docs > > > > wasn't changed I made a patch to restore the previous behavior. > > > > > > Changing that behavior was the entire point of the cited commit. > > > > Sorry, I was thinking that the new behavior was needed for internal > > future functions since the doc wasn't changed. > > FWIW, I also don't think it's ok to just change the behaviour > unconditionally and without a replacement for existing behaviour. Seems like it just needs a new argument nowait DEFAULT false Craig Ringer http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Commits
-
Restore behavior for replication origin drop
- f15b76a9010d 10.0 landed
- a6979c3a68e2 11.0 landed
-
Add a WAIT option to DROP_REPLICATION_SLOT
- 8ba6d50f923b 10.0 landed
- be7161566db2 11.0 landed
-
Fix race conditions in replication slot operations
- 9915de6c1cb2 10.0 cited