Operational issues when max_replication_slots is exhausted

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/

Responses

Browse pgsql-general by date

  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