checking session status
checking session status
От:
s.chava@wcom.com (Srinivasa Rao Chava)
Дата:
Hi, How to check the session status in postgresql.Say, I want to check who is logged in to the database at the moment. In ,oracle , I use v$session view which gives the users logged in to the database. But I don't know how to do it postgresql. With ps -ef | grep postmaster* command , I can know how many postgres processes are running. But How to know which process belong to which database user account. Thanks for any help chava