Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slothandling - Mailing list pgsql-hackers

From Peter Eisentraut
Subject Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slothandling
Date
Msg-id 1edf7681-9ac6-3e26-d03e-22ae3d6c0b30@2ndquadrant.com
Whole thread Raw
In response to Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slot handling  (Michael Paquier <michael.paquier@gmail.com>)
List pgsql-hackers
On 4/20/17 08:41, Michael Paquier wrote:
> As subscription is a self-contained concept, it seems to me that any
> errors happening should at least try to do some cleanup action before
> just giving up processing, that would be a less frustrating
> experience.

This is the way it's designed.

The alternative is to do what we currently do for physical replication,
namely requiring the user to set up all the replication slots manually
beforehand.  I don't think that's a better experience.  There was a
thread about having pg_basebackup automatically create replication
slots.  That will have to deal with the same issues.

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



pgsql-hackers by date:

Previous
From: Alvaro Herrera
Date:
Subject: [HACKERS] WITH clause in CREATE STATISTICS
Next
From: Tom Lane
Date:
Subject: Re: [HACKERS] Removing select(2) based latch (was Unportable implementation of background worker start)