Thread: param max_connections
Hallo, I am using PostgreSQL 7.4 on UltraSparc machine and I have a touble with max_connections param. I must set only max_connections to 8, when I set more, I got error for shared memory. Most connection is from J2EE application server and here is no problem, I am using connection pooling and I have defined maximum connections for each datasource here, but there is an old application written in php too, and here is a problem, sometime connections runs over this param value. Is this param familiar or I have a problem somewhere in configuration / compilation? Server has 1 CPU UltraSparc II and 512MB RAM Thanks for help, Jiri
On Thursday 18 December 2003 08:34, konf@chalu.cz wrote: > Hallo, > I am using PostgreSQL 7.4 on UltraSparc machine and I have a touble with > max_connections param. > I must set only max_connections to 8, when I set more, I got error for > shared memory. > Is this param familiar or I have a problem somewhere in configuration / > compilation? You should increase you shared memory settings. You probably want to do some other tuning too if you haven't done any. There are two good articles on the configuration file and tuning here: http://www.varlena.com/varlena/GeneralBits/Tidbits/index.php -- Richard Huxton Archonet Ltd