Last access date for databases/users

From: Marc McIntyre <mmcintyre(at)squiz(dot)net>
To: pgsql-sql(at)postgresql(dot)org
Subject: Last access date for databases/users
Date: 2005-09-02 02:58:07
Message-ID: 4317BFBF.8080302@squiz.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Is there anyway to determine when a database was last accessed, or when
a user last connected to the database using the pg_* views? I'm trying
to determine what databases in my system are currently active.

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Graf László 2005-09-02 07:26:04 ERROR: syntax error at or near "select" at character 9
Previous Message Michael Fuhr 2005-09-02 02:03:46 Re: queries problems