Re: Where is the connection info

From: Hannu Krosing <hannu(at)tm(dot)ee>
To: "Cason, Kenny" <kenny(dot)cason(at)boeing(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Where is the connection info
Date: 2004-12-01 21:53:21
Message-ID: 1101938001.4005.0.camel@fuji.krosing.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On K, 2004-12-01 at 18:28, Cason, Kenny wrote:
> In postgres, how do I find out how many connections are allowed per
> user? Where those connections are stored? Who has the connections? Etc.

You can start from:

show all;

select * from pg_stat_activity;

---------
Hannu

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2004-12-01 21:59:49 Re: libpq and psql not on same page about SIGPIPE
Previous Message Oliver Jowett 2004-12-01 21:52:16 Re: libpq and psql not on same page about SIGPIPE