This was my message:
PDT FATAL: remaining connection slots are reserved for
non-replication superuser connections
Reading about, some points to max_connections because we have increase
users on the network, I tought has sense.
In 2 weeks will upgrade to ubuntu 14+psql 9.3
The docs say 25% of the memory, them I put there 18GB increasing
kernel settings.
Now need to support this version, on 9.3 this settings changes?
Thanks.
On Wed, Aug 3, 2016 at 11:02 PM, John R Pierce <pierce@hogranch.com> wrote:
> On 8/3/2016 10:13 PM, Periko Support wrote:
>>
>> This send me a message about shared_memory need to lower the value
>> which default settings = 24MB.
>
>
> what message was this, exactly ?
>
>
> on a 128GB ram system, I would probably have shared_buffers up around 4-8GB.
>
>
> btw, postgres 9.1 is getting on in age, and will soon be desupported, newer
> versions no longer used SysV shm, so you no longer need to adjust shmmax
> values in your kernel.
>
>
>
>
> --
> john r pierce, recycling bits in santa cruz
>
>
>
> --
> Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
