Skip site navigation (1) Skip section navigation (2)

Re: list of open connections / terminate a connection?

From: Ken Godee <ken(at)perfect-image(dot)com>
To: David Teran <david(dot)teran(at)cluster9(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: list of open connections / terminate a connection?
Date: 2004-05-20 14:41:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-general
> is it possible (i am pretty sure) to list the open connections clients 
> have to a particular database and to force close the connection?
> regards David

pgaccess comes with a program called "pgmonitor"
pgmonitor does what your looking for.

In response to

pgsql-general by date

Next:From: Dragan MaticDate: 2004-05-20 14:49:31
Subject: problem with sorting using 'ORDER BY' when character field is filled with numerical values
Previous:From: Tom LaneDate: 2004-05-20 14:35:52
Subject: Re: Unresponsive vacuum process

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group