|
Hi there,
First i must say that iv started using pgsql
recently(on a linux redhat apache server with mod perl "DBI"). I have this
problem after a little while there is too many pgsql process hanging "idle" and
when we try to connect the server say: psql: Sorry, too many clients already
when im trying to connect from the shell.
All the scripts im running connect once and use the
same connection for the runtime then disconnect() at the end... but some process are starting to get idle(i can see them while
doing a "top"... I heard that i could get raise number of connection
(default suppose to be 32 ?) but i cant find the way or the documentation to do
it. Im using this command to start the postmaster:
pg_ctl -l /export/datafiles/pgsql/postmaster.log -D
/export/datafiles/pgsql/data start
and iv tried these option "-i -B 256 -N 128" but it always say
bad param, there is no documentation in pg_ctl --help concerning this
issue.
Its will probably be easy for a postgress teamember to
anser me :)
Thanks in advance, Ken
|
