In postgresql.conf you can enable connections logs. log_connections = on
> From: walterc@indiana.edu
> To: pgsql-admin@postgresql.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@postgresql.org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-admin
Conoce el perfil completo de todos tus amigos de Windows Live Messenger justo aquí:
Windows Live Spaces