Operational issues when max_replication_slots is exhausted - Mailing list pgsql-general

From Ahmed Et-tanany
Subject Operational issues when max_replication_slots is exhausted
Date
Msg-id CAD7nQBASDnsxiThkH3=SZLb-=uBT7GJvZBxqY9PYUNHJdSeESA@mail.gmail.com
Whole thread Raw
Responses Re: Operational issues when max_replication_slots is exhausted
Re: Operational issues when max_replication_slots is exhausted
List 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 by date:

Previous
From: "Colin 't Hart"
Date:
Subject: pgBackrest and newer timelines
Next
From: Laurenz Albe
Date:
Subject: Re: Operational issues when max_replication_slots is exhausted