MDT FATAL: sorry, too many clients already (Error de Postgres 9)

When-to-fire-a-client-mainTo increase the connection you may like the following document. This solution is tested on ubuntu 12.04.

1. Make following changes in postgresql.conf file :

open /etc/postgresql/9.1/main/postgresql.conf

shared_buffers = 100MB
max_files_per_process = 100

link : ( shared_buffers size should be less than shmmax size.)

2. Commands to check shmmax:

$ sysctl -e kernel.shmmax
$ ipcs -l

link : (

3. Increase the size of shmmax: run the follwing command.

$ sysctl -w kernel.shmmax=134217728 
$ sysctl -w kernel.shmall=2097152

and write on top in /etc/sysctl.conf file:


link : (

4. About:(links)

5. restart postgresql

$ service postgresql restart




También te podría gustar...

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *