From: Fabricio <fabrixio1@hotmail.com>
To: walterc@indiana.edu
To: pgsql-admin@postgresql.org
Subject: Re: User info?
Date: Wed, 3 Dec 2008 11:09:00 -0700
Message-ID: <BLU103-W4648C4CEAC672428F6526FFE030@phx.gbl> (raw)
In-Reply-To: <5E8A5F66-0D56-4955-9EBD-E35E3098195D@indiana.edu>
References: <5E8A5F66-0D56-4955-9EBD-E35E3098195D@indiana.edu>
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_________________________________________________________________
Live Search premia tus búsquedas, llévate hasta ¡Un Auto!
http://www.ganabuscando.com/Default.aspx=
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: fabrixio1@hotmail.com, walterc@indiana.edu
Subject: Re: User info?
In-Reply-To: <BLU103-W4648C4CEAC672428F6526FFE030@phx.gbl>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox