Feedback-ID: i76984098:Fastmail
Message-ID: <9b002550-887e-49b0-98e4-6df5f0759af0@aklaver.com>
Date: Mon, 16 Jun 2025 11:13:25 -0700
MIME-Version: 1.0
User-Agent: Mozilla Thunderbird
Subject: Re: Getting error "too many clients already" despite having a db
 connection limit set
To: "David G. Johnston" <david.g.johnston@gmail.com>
Cc: adolfo flores <adolfoflores2211@gmail.com>,
 pgsql-general@lists.postgresql.org
References: <CADM4kyuO39mr8E_xDw4GGi2v9gCK0dq52fKj40FcsXJeKxgRrA@mail.gmail.com>
 <484c43a4-962d-44ed-af87-e5abde63bd04@aklaver.com>
 <CAKFQuwa0t-L_zxuseJtOyf6F32V7pFdEw90wgyo769he+CdW4Q@mail.gmail.com>
Content-Language: en-US
From: Adrian Klaver <adrian.klaver@aklaver.com>
In-Reply-To: <CAKFQuwa0t-L_zxuseJtOyf6F32V7pFdEw90wgyo769he+CdW4Q@mail.gmail.com>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 8bit
Archived-At: <https://www.postgresql.org/message-id/9b002550-887e-49b0-98e4-6df5f0759af0%40aklaver.com>
Precedence: bulk


On 6/16/25 11:09 AM, David G. Johnston wrote:
> 
> 
>
>     I am not understanding the above. The connection limit from the
>     database
>     side is going to be the value for max_connections. It is not clear
>     to me
>     what "...  connection limit of 30% of the max_connections setting" is
>     referring to?
> 
> 
> See "alter database ... set"

Aah, forgot about that.

> 
> David J.
> 
> 

-- 
Adrian Klaver
adrian.klaver@aklaver.com