Operational issues when max_replication_slots is exhausted

Поиск
Список
Период
Сортировка
От Ahmed Et-tanany
Тема Operational issues when max_replication_slots is exhausted
Дата
Msg-id CAD7nQBASDnsxiThkH3=SZLb-=uBT7GJvZBxqY9PYUNHJdSeESA@mail.gmail.com
обсуждение исходный текст
Ответы Re: Operational issues when max_replication_slots is exhausted
Re: Operational issues when max_replication_slots is exhausted
Список pgsql-general
Hello PostgreSQL community,

We have an issue related to `max_replication_slots` that I am not sure would qualify as a bug,
so I thought I would ask here first.

Our problem is that when our customers use up all available replication slots for logical replication,
our database management tasks that also require a slot fail (for example, creating the required
replication slot for a new physical standby). Since increasing `max_replication_slots` requires
a restart, we would like to avoid that if possible.

One idea we have considered is patching PostgreSQL to add a new GUC parameter that would allow
a superuser to reserve a certain number of replication slots usable only for management tasks.

Is this a known issue that might be addressed in PostgreSQL at some point? If not,
what would be a good way to solve this problem?

Thanks in advance.

Best regards,

--
Ahmed Et-tanany
Aiven: https://aiven.io/

В списке pgsql-general по дате отправления: