In postgresql.conf you can enable connections logs. log_connections = on
> From: walterc(at)indiana(dot)edu> To: pgsql-admin(at)postgresql(dot)org> Subject: [ADMIN] User info?> Date: Wed, 3 Dec 2008 10:30:22 -0500> > 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?> > Carol> > -- > Sent via pgsql-admin mailing list (pgsql-admin(at)postgresql(dot)org)> To make changes to your subscription:> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
Live Search premia tus búsquedas, llévate hasta ¡Un Auto!
http://www.ganabuscando.com/Default.aspx