Thread: Pgsql question

Pgsql question

From
"Ken Mathieu"
Date:
Hi there,=20

  First i must say that iv started using pgsql recently(on a linux redhat a=
pache server with mod perl "DBI").  I have this problem after a little whil=
e 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 co=
nnect from the shell.=20

 All the scripts im running connect once and use the same connection for th=
e 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 ra=
ise number of connection (default suppose to be 32 ?) but i cant find the w=
ay or the documentation to do it.  Im using this command to start the postm=
aster:=20

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, t=
here 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