ps -ef | grep post
postgres 4571 27462 0 12:02 ? 00:00:00 postgres: medi Test1
[local] idl
says, some guy name 'medi' is connected to database 'Test1' via process
ID 4571.
or
psql -c "select * from pg_stat_activitity"
datid | datname | procpid | usesysid | usename | current_query
-------+---------+---------+----------+---------+---------------
16556 | Test1 | 4571 | 100 | medi |
(1 row)
Which says some guy named 'medi' is connecting to database 'Test1' via
process ID 4571.
Isn't PG cool....
juleni wrote:
>Hello,
> Is it possible to show a list of all currently connected users into the
>specific postgres database (what's the command)?
>
> Thanks,
> Julian
>
>mailto:juleni@seznam.cz
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
