Обсуждение: Too many clients
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, Postgesql v7.3.2, os/2. I am using JDBC to connect to the dbms. After a few program open/close I get the message "Sorry, too many clients already". Supposedly my database class properly closes the connection when it is removed. Maybe not. How do I see who and how many connections there are? How would I terminate orphaned connections? - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/P9RtsxxMki0foKoRAinQAJ9VilZRPuosuOVG1LZrrHs6IvgD9ACfTxw+ 51kchvI9NqLG1faJiyXE3Vk= =Ff76 -----END PGP SIGNATURE-----
select A.datname, A.procpid, S.usename, A.current_query from pg_stat_activity A inner join pg_shadow S on (A.usesysid=S.usesysid);
will give you the information you need.
On Sun, 2003-08-17 at 16:15, James Moe wrote:
will give you the information you need.
On Sun, 2003-08-17 at 16:15, James Moe wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 Hello, Postgesql v7.3.2, os/2. I am using JDBC to connect to the dbms. After a few program open/close I get the message "Sorry, too many clients already". Supposedly my database class properly closes the connection when it is removed. Maybe not. How do I see who and how many connections there are? How would I terminate orphaned connections? - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -----BEGIN PGP SIGNATURE----- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/P9RtsxxMki0foKoRAinQAJ9VilZRPuosuOVG1LZrrHs6IvgD9ACfTxw+ 51kchvI9NqLG1faJiyXE3Vk= =Ff76 -----END PGP SIGNATURE----- ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)