Re: Strange connection limit problem - Mailing list pgsql-general

From Giuseppe Sacco
Subject Re: Strange connection limit problem
Date
Msg-id d08d75e452765225f1cd955570aa2c5e9cfb4828.camel@eppesuigoccas.homedns.org
Whole thread Raw
In response to Strange connection limit problem  (Ict Security <ict.security.job@gmail.com>)
List pgsql-general
Hi Frank,

Il giorno ven, 07/06/2019 alle 13.58 +0200, Ict Security ha scritto:
> Dear guys,
> 
> i have two identical Postgresql 9.6.1 and i need, to test an
> application, to reach connection above 1024.
> 
> I setup 2400 as max_connections
> I raised file-max kernel limit to 65535
> I increased shared_buffers
> I also increased the value in semaphores in both
> And i added this in limits.conf:
> * - nofile 999999
[...]

Is postgresql ran via systemd? If this is the case, limits.conf is
ignored and you should put the limits in the systemd unit file.

Bye,
Giuseppe




pgsql-general by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Strange connection limit problem
Next
From: Tom Lane
Date:
Subject: Re: Snowball Stemming Greek support not included in Release 12 beta