Pgsql question
| От | Ken Mathieu |
|---|---|
| Тема | Pgsql question |
| Дата | |
| Msg-id | 000a01c18202$425cad80$7d25c818@videotron.ca обсуждение исходный текст |
| Список | pgsql-bugs |
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
В списке pgsql-bugs по дате отправления: