Re: Strange connection limit problem

From: Giuseppe Sacco <giuseppe(at)eppesuigoccas(dot)homedns(dot)org>
To: Ict Security <ict(dot)security(dot)job(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Strange connection limit problem
Date: 2019-06-07 13:28:20
Message-ID: d08d75e452765225f1cd955570aa2c5e9cfb4828.camel@eppesuigoccas.homedns.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2019-06-07 13:41:23 Re: Snowball Stemming Greek support not included in Release 12 beta
Previous Message Laurenz Albe 2019-06-07 13:24:13 Re: Strange connection limit problem