Re: Finding active connections to postmaster

> 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