| From: | Ahmed Et-tanany <ahmed(dot)ettanany(at)aiven(dot)io> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Operational issues when max_replication_slots is exhausted |
| Date: | 2025-12-15 11:58:43 |
| Message-ID: | CAD7nQBASDnsxiThkH3=SZLb-=uBT7GJvZBxqY9PYUNHJdSeESA@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2025-12-15 15:17:52 | Re: Operational issues when max_replication_slots is exhausted |
| Previous Message | Colin 't Hart | 2025-12-10 11:43:01 | pgBackrest and newer timelines |