PostgreSQL问题解决--连接数过多

stackoverflow–org.postgresql.util.PSQLException: FATAL: sorry, too many clients already

1.First find your postgresql.conf file
2.If you don’t know where it is, query the database with the sql: SHOW config_file;
3.Mine is in: /var/lib/pgsql/data/postgresql.conf
4.Login as root and edit that file.
6.5.Search for the string: “max_connections”.
7.You’ll see a line that says max_connections=100.
8.Set that number bigger, check the limit for your postgresql version.
9.Restart the postgresql database for the changes to take effect.