On Nov 30, 2007 2:55 PM, Tena Sakai <tsakai@xxxxxxxxxxxxxx> wrote: > On my postgres 8.1.1, I get a response > psql: FATAL: connection limit exceeded for non-superusers > 1) Is this to do with max_connections setting in the postgres > configuration file? (my setting is 100 (I think this is the > default).) Yep. > 2) how would I look at the "open/used" connections? select * from pg_stat_activity; > 3) should I try restarting postgres without changing the setting? Has to be restarted for change to take effect. > 4) what repercussion would there be if I increase this number to, > say, 200? (and would that be a good idea?) A little overhead, nothing bad. > 5) finally, what's the best fix? (Do I need to go to pgpool?) see pgbouncer -- Jonah H. Harris, Sr. Software Architect | phone: 732.331.1324 EnterpriseDB Corporation | fax: 732.331.1301 499 Thornall Street, 2nd Floor | jonah.harris@xxxxxxxxxxxxxxxx Edison, NJ 08837 | http://www.enterprisedb.com/ ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate
