Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVBO6-00F5K2-1z for pgsql-general@arkaria.postgresql.org; Mon, 15 Dec 2025 16:25:31 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.96) (envelope-from ) id 1vVBO5-00146M-0z for pgsql-general@arkaria.postgresql.org; Mon, 15 Dec 2025 16:25:30 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVBO4-00146E-17 for pgsql-general@lists.postgresql.org; Mon, 15 Dec 2025 16:25:29 +0000 Received: from fhigh-a2-smtp.messagingengine.com ([103.168.172.153]) by makus.postgresql.org with esmtps (TLS1.3) tls TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384 (Exim 4.96) (envelope-from ) id 1vVBO3-000oWk-0J for pgsql-general@lists.postgresql.org; Mon, 15 Dec 2025 16:25:28 +0000 Received: from phl-compute-04.internal (phl-compute-04.internal [10.202.2.44]) by mailfhigh.phl.internal (Postfix) with ESMTP id 6C19D14001CD; Mon, 15 Dec 2025 11:25:25 -0500 (EST) Received: from phl-mailfrontend-01 ([10.202.2.162]) by phl-compute-04.internal (MEProxy); Mon, 15 Dec 2025 11:25:25 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=aklaver.com; h= cc:content-transfer-encoding:content-type:content-type:date:date :from:from:in-reply-to:in-reply-to:message-id:mime-version :references:reply-to:subject:subject:to:to; s=fm3; t=1765815925; x=1765902325; bh=C5PLLYECvtH3j/k+qCPYWcOMoH2CqnutXcxaq2F814s=; b= Q/CqR3UdgAtEFHVkpkdEU4kP80DB9PEwfUX22bDRjMPR4nS2Qk5vcX9+ljSdYBlP oUxwiDNAGOiBHT5PKURX6sSbgUNvmQkMelyXwW7yL8o9i7MScg/UqK/jUvzF1SmV I3tNt/MAwvZpno6Yt77RQTcUBjBvk0D2lo1nQMKtO+jL4X1bbvr9cKQ8kS3OWdTB kgiC+FZkUvVgZA20tDM9YV7XHazG5v68VBMa3Y2AKErkIpGGTWvQhvHowf0kE0HE kU3aVR6RoYexTjI5Ah8M0VtqLxv8UsOdob0Za79ZR7DjwgxHpfYrdG9z+H5XE5hS XNC5c21FhoI6nHUxBzfxOg== DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :content-type:date:date:feedback-id:feedback-id:from:from :in-reply-to:in-reply-to:message-id:mime-version:references :reply-to:subject:subject:to:to:x-me-proxy:x-me-sender :x-me-sender:x-sasl-enc; s=fm1; t=1765815925; x=1765902325; bh=C 5PLLYECvtH3j/k+qCPYWcOMoH2CqnutXcxaq2F814s=; b=qoOGULTayjCB55S/b sh0EvGUxCcQrKeSkAgYnuouHXTvG+iBfTUobkRoBAIsa8+fhLMSdN7x3Q8m05u81 jWvD7BZGMeRia56dJ0MQzw4tUSeLvMqwq8yVHW/Unr/opROKr7u+EDzWd0Nd3617 1USjqfA61hxotZG93biuzScywLT2LjApEmgdB+WZy8j4Do0W0H4574qjQHNIxEWC ivKDtA4OnR5oKA57JOgQyzyxs3Q/No7qXZl12szx1Ebj1RUPhRNvFO0zSH5kHwnn MkMJm2U1n0WsXLI6STGWVGJwY/zB72zFI6rLS+NfYj1g3suxcBKfXIT/34qHFvOs v5znQ== X-ME-Sender: X-ME-Received: X-ME-Proxy-Cause: gggruggvucftvghtrhhoucdtuddrgeefgedrtddtgdefjedvlecutefuodetggdotefrod ftvfcurfhrohhfihhlvgemucfhrghsthforghilhdpuffrtefokffrpgfnqfghnecuuegr ihhlohhuthemuceftddtnecusecvtfgvtghiphhivghnthhsucdlqddutddtmdenucfjug hrpefkffggfgfuvfhfhfgjtgfgsehtjeertddtvdejnecuhfhrohhmpeetughrihgrnhcu mfhlrghvvghruceorggurhhirghnrdhklhgrvhgvrhesrghklhgrvhgvrhdrtghomheqne cuggftrfgrthhtvghrnhepiedtfeejgeejheefieduudeujeeivdejleeiieethedukeef teehjeelueelgeetnecuffhomhgrihhnpegrihhvvghnrdhiohenucevlhhushhtvghruf hiiigvpedtnecurfgrrhgrmhepmhgrihhlfhhrohhmpegrughrihgrnhdrkhhlrghvvghr segrkhhlrghvvghrrdgtohhmpdhnsggprhgtphhtthhopedvpdhmohguvgepshhmthhpoh huthdprhgtphhtthhopegrhhhmvggurdgvthhtrghnrghnhiesrghivhgvnhdrihhopdhr tghpthhtohepphhgshhqlhdqghgvnhgvrhgrlheslhhishhtshdrphhoshhtghhrvghsqh hlrdhorhhg X-ME-Proxy: Feedback-ID: i76984098:Fastmail Received: by mail.messagingengine.com (Postfix) with ESMTPA; Mon, 15 Dec 2025 11:25:24 -0500 (EST) Message-ID: <733844b2-2926-49cc-9bd9-ff06999c3933@aklaver.com> Date: Mon, 15 Dec 2025 08:25:23 -0800 MIME-Version: 1.0 User-Agent: Mozilla Thunderbird Subject: Re: Operational issues when max_replication_slots is exhausted To: Ahmed Et-tanany , pgsql-general@lists.postgresql.org References: Content-Language: en-US From: Adrian Klaver In-Reply-To: Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On 12/15/25 03:58, Ahmed Et-tanany wrote: > 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, The above would be the issue. Allowing customers to be DBA's for an installation that they are not ultimately responsible for does not seem sound to me. I would think a request mechanism is in order. > > Thanks in advance. > > Best regards, > > -- > Ahmed Et-tanany > Aiven: https://aiven.io/ -- Adrian Klaver adrian.klaver@aklaver.com