Re: Finding active connections to postmaster - Mailing list pgsql-admin

> Is it possible to list active connectons? How?
>

This will give a unique list of the names of those logged on:

echo Current users logged onto database:
ps ax | grep postgres: | awk '{print $6 | "sort" } ' | uniq


This will list the user and what process is being done:

ps ax | grep postgres: | awk '{print $6 ":"  $9 " on " $7}'


HTH,
-Tony