King_Henree(at)yahoo(dot)com wrote:
> In Oracle you can look at the v$session view to get
> session information and how long they have been
> running. What is the equivalent in PostgreSQL?
>
> TIA.
>
I enable logging of the logins +date/time +pid in postgresql.conf
log_connections=true
log_timestamp=true
log_pid=true
I then just grep the postmaster log for the pid & look at the last entry
There may well be another method, but hth
- Stuart