On Wed, Dec 3, 2008 at 8:30 AM, Carol Walter <walterc@xxxxxxxxxxx> wrote: > Is there a way to tell when the last time a database in a cluster was > accessed? I have a large number of student databases that are probably > inactive, but I don't want to just destroy. I'd like to archive these, but > I need to be able to tell when they were last accessed? No direct method from within the db I know of, but you could use oid2name / a list of db relids then go into the data/base directory and see when the last time the files in the individual db directories had been updated. That won't tell you the last time they were ACCESSED, but will give you an idea if they're being updated or not. Note that vacuum may change the last update times so it's not foolproof by any means. The other method is to log connections and then scrape the logs. -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
