pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedusers 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