470,647 Members | 1,187 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,647 developers. It's quick & easy.

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/P9RtsxxMki0foKoRAinQAJ9VilZRPuosuOVG1LZrrHs6IvgD9A CfTxw+
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 ma*******@postgresql.org)

Nov 11 '05 #1
1 3116
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:
-----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/P9RtsxxMki0foKoRAinQAJ9VilZRPuosuOVG1LZrrHs6IvgD9A CfTxw+
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 ma*******@postgresql.org)


-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.2.2 (FreeBSD)

iD8DBQA/QjJg21dVnhLsBV0RAnnRAJwPz+oZe8EFWaF7xtv6Bx9eL3KayA CeKKEy
NXr6wFuXJPr0/j3iuEE9A98=
=wt+D
-----END PGP SIGNATURE-----

Nov 11 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

6 posts views Thread by Guy Robinson | last post: by
65 posts views Thread by Pmb | last post: by
2 posts views Thread by jasonsgeiger | last post: by
reply views Thread by warner | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.