pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
users connected
3+ messages / 3 participants
[nested] [flat]

* users connected
@ 2004-07-16 14:42 Cardoso Patrick <cardoso@iut-rodez.fr>
  2004-07-19 21:26 ` Re: users connected Robert Treat <xzilla@users.sourceforge.net>
  2004-07-19 21:31 ` Re: users connected Gaetano Mendola <mendola@bigfoot.com>
  0 siblings, 2 replies; 3+ messages in thread

From: Cardoso Patrick @ 2004-07-16 14:42 UTC (permalink / raw)
  To: pgsql-admin

Hi,
 
            Is it possible to know the number of users connected to a
database ?
 
            Regards
 
 

^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: users connected
  2004-07-16 14:42 users connected Cardoso Patrick <cardoso@iut-rodez.fr>
@ 2004-07-19 21:26 ` Robert Treat <xzilla@users.sourceforge.net>
  1 sibling, 0 replies; 3+ messages in thread

From: Robert Treat @ 2004-07-19 21:26 UTC (permalink / raw)
  To: Cardoso Patrick <cardoso@iut-rodez.fr>; +Cc: pgsql-admin

On Fri, 2004-07-16 at 10:42, Cardoso Patrick wrote:
> Hi,
>  
>             Is it possible to know the number of users connected to a
> database ?
>  
>             Regards
>  
>  

select * from pg_stat_activity;

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL




^ permalink  raw  reply  [nested|flat] 3+ messages in thread

* Re: users connected
  2004-07-16 14:42 users connected Cardoso Patrick <cardoso@iut-rodez.fr>
@ 2004-07-19 21:31 ` Gaetano Mendola <mendola@bigfoot.com>
  1 sibling, 0 replies; 3+ messages in thread

From: Gaetano Mendola @ 2004-07-19 21:31 UTC (permalink / raw)
  To: Cardoso Patrick <cardoso@iut-rodez.fr>; pgsql-admin

Cardoso Patrick wrote:
> Hi,
> 
>  
> 
>  Is it possible to know the number of users connected to a database ?

select * from pg_stat_activity.

I'm not sure about permissions you need for it, try.



Regards
Gaetano Mendola






^ permalink  raw  reply  [nested|flat] 3+ messages in thread


end of thread, other threads:[~2004-07-19 21:31 UTC | newest]

Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-07-16 14:42 users connected Cardoso Patrick <cardoso@iut-rodez.fr>
2004-07-19 21:26 ` Robert Treat <xzilla@users.sourceforge.net>
2004-07-19 21:31 ` Gaetano Mendola <mendola@bigfoot.com>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox