Re: Tunning Server 9.1.

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(at)hogranch(dot)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general