CREATE SUBSCRIPTION uninterruptable

On 2/16/17 09:44, Thom Brown wrote:

I've noticed that when creating a subscription, it can't be
interrupted. One must wait until it times out, which takes just over
2 minutes. I'm guessing ALTER SUBSCRIPTION would have the same
problem.

Shouldn't we have an interrupt for this?

I think this is addressed by these patches:
https://commitfest.postgresql.org/13/991/

Please give them a try.

--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

On 17 February 2017 at 14:14, Peter Eisentraut
<peter.eisentraut@2ndquadrant.com> wrote:

On 2/16/17 09:44, Thom Brown wrote:

I've noticed that when creating a subscription, it can't be
interrupted. One must wait until it times out, which takes just over
2 minutes. I'm guessing ALTER SUBSCRIPTION would have the same
problem.

Shouldn't we have an interrupt for this?

I think this is addressed by these patches:
https://commitfest.postgresql.org/13/991/

Please give them a try.

Okay, I've now tested those patches, and they do indeed fix this problem for me.

Thanks

Thom

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers