PostgreSQL OpenSource Database

5.5 PostgreSQL Geek Problems

5.4 Backup & Restore [  up  ] - [ TOC ] - [ A - Z ] 6 Postgres Tools


  • PostgreSQL: too many clients already 2004-01-24 01:29
    unable to connect to PostgreSQL server: Sorry, too many clients already

    Apache Log:
    [Sat Jan 24 21:00:00 2004] [error] [client 64.235.238.142] mod_auth_pgsql database connection error reset failed FATAL: Sorry, too many clients already

    Solution:
    vi /usr/local/pgsql/data/postgresql.conf

    Increase the value of the key max_connections from 32 to 64.

    shared_buffers = 128 # min max_connections*2 or 16, 8KB each


  • readline library not found 2004-09-21 16:28
    configure: error: readline library not found
    If you have readline already installed, see config.log for details on the
    failure. It is possible the compiler isn't looking in the proper directory.
    Use --without-readline to disable readline support.






copyright by reto - created with mytexi
$Id: geek-problems.html,v 1.30 2007/03/07 08:41:03 webcms Exp $