Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slothandling

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slothandling
Дата
Msg-id 1edf7681-9ac6-3e26-d03e-22ae3d6c0b30@2ndquadrant.com
обсуждение исходный текст
Ответ на Re: [HACKERS] DROP SUBSCRIPTION, query cancellations and slot handling  (Michael Paquier <michael.paquier@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: [HACKERS] WITH clause in CREATE STATISTICS
Следующее
От: Tom Lane
Дата:
Сообщение: Re: [HACKERS] Removing select(2) based latch (was Unportable implementation of background worker start)