Sorry Tom for the duplicate email. Resending with the mailing list.
> Thanks for your response. I'm using a Centos Linux environment and have > the open files set very high: > > -bash-4.2$ ulimit -a|grep open > open files (-n) 65000 > > What else could be limiting the connections? > > Kevin > > > On Sat, 20 Aug 2022 at 21:20, Tom Lane <t...@sss.pgh.pa.us> wrote: > >> Kevin McKibbin <kevinmckibbin...@gmail.com> writes: >> > What's limiting my DB from allowing more connections? >> >> > This is a sample of the output I'm getting, which repeats the error 52 >> > times (one for each failed connection) >> >> > -bash-4.2$ pgbench -c 200 -j 200 -t 100 benchy >> > ... >> > connection to database "benchy" failed: >> > could not connect to server: Resource temporarily unavailable >> > Is the server running locally and accepting >> > connections on Unix domain socket >> > "/var/run/postgresql/.s.PGSQL.5432"? >> >> This is apparently a client-side failure not a server-side failure >> (you could confirm that by seeing whether any corresponding >> failure shows up in the postmaster log). That means that the >> kernel wouldn't honor pgbench's attempt to open a connection, >> which implies you haven't provisioned enough networking resources >> to support the number of connections you want. Since you haven't >> mentioned what platform this is on, it's impossible to say more >> than that --- but it doesn't look like Postgres configuration >> settings are at issue at all. >> >> regards, tom lane >> >
