Last active time for a database

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Last active time for a database
Date: 2014-09-08 19:27:59
Message-ID: CAMkU=1yge8Ts8+k0DD87h+tUHXFDTPXxcyb_RRCco8WroYZ3JQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is there a way for a superuser to find the last time a database had an
active user connection? (While being logged into a different database in
the same instance, of course).

The context here is looking for looking for automated integration testing
databases that have been leaked due to bugs/crashes in the testing
framework.

Yes, I can mine the server log files, but that is really scraping the
bottom of the barrel.

Thanks

Jeff

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Brandl 2014-09-08 20:40:21 Re: Querying a time range across multiple partitions
Previous Message klo uo 2014-09-08 19:06:00 Re: How to restore backup database