Re: pgbench: could not connect to server: Resource temporarily unavailable

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 <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>
>> Kevin McKibbin <kevinmckibbin123(at)gmail(dot)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
>>
>