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/
Aiven: https://aiven.io/
В списке pgsql-general по дате отправления: