From: | Franco Bruno Borghesi <franco(at)akyasociados(dot)com(dot)ar> |
---|---|
To: | James Moe <jimoe(at)sohnen-moe(dot)com> |
Cc: | Postgresql General Mail List <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Too many clients |
Date: | 2003-08-19 14:21:21 |
Message-ID: | 1061302881.891.3.camel@taz.oficina |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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/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(at)postgresql(dot)org)
>
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera | 2003-08-19 14:23:32 | Re: Mailing list in French |
Previous Message | Lincoln Yeoh | 2003-08-19 14:20:04 | Re: Buglist |