Did you get an answer to this?
If you are on a unix machine you can check the processes (using ps)
and then grep for pgsql or the postgres user.
Once you have that list, you can kill the individual processes (if you have
the proper permissions).
Jd
On Tue, 6 Jun 2000, Tim White wrote:
> Is there a way to view the active/inactive connections to PostgreSQL 6.5.3?
> And if so is it possible to kill those that are inactive? I'm having
> difficulty in testing using a Java application, where connections are
> established and then not being destroyed properly. This causes me to get an
> error message stating that there are "...too many clients already.".
>
> Any help is greatly appreciated.
>
> Tim White
>