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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
