Received: from localhost (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id B3B1E650350
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  3 Dec 2008 14:09:05 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 56102-05 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Wed,  3 Dec 2008 14:09:01 -0400 (AST)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from blu0-omc2-s17.blu0.hotmail.com (blu0-omc2-s17.blu0.hotmail.com
	[65.55.111.92])
	by mail.postgresql.org (Postfix) with ESMTP id C215865034D
	for <pgsql-admin@postgresql.org>; Wed,  3 Dec 2008 14:09:01 -0400 (AST)
Received: from BLU103-W46 ([65.55.111.73]) by blu0-omc2-s17.blu0.hotmail.com
	with Microsoft SMTPSVC(6.0.3790.3959);
	Wed, 3 Dec 2008 10:09:00 -0800
Message-ID: <BLU103-W4648C4CEAC672428F6526FFE030@phx.gbl>
Content-Type: multipart/alternative;
	boundary="_53247eaf-24ed-46b6-a694-1b2ed0a88302_"
X-Originating-IP: [201.147.232.187]
From: Fabricio <fabrixio1@hotmail.com>
To: <walterc@indiana.edu>, <pgsql-admin@postgresql.org>
Subject: Re: User info?
Date: Wed, 3 Dec 2008 11:09:00 -0700
Importance: Normal
In-Reply-To: <5E8A5F66-0D56-4955-9EBD-E35E3098195D@indiana.edu>
References: <5E8A5F66-0D56-4955-9EBD-E35E3098195D@indiana.edu>
MIME-Version: 1.0
X-OriginalArrivalTime: 03 Dec 2008 18:09:00.0353 (UTC)
	FILETIME=[378F2310:01C95572]
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.001 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001
X-Spam-Level: 
X-Archive-Number: 200812/20
X-Sequence-Number: 30853

--_53247eaf-24ed-46b6-a694-1b2ed0a88302_
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable


In postgresql.conf you can enable connections logs. log_connections =3D on
> From: walterc@indiana.edu> To: pgsql-admin@postgresql.org> Subject: [ADMI=
N] User info?> Date: Wed=2C 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 la=
rge number of student databases that are > probably inactive=2C but I don't=
 want to just destroy. I'd like to > archive these=2C but I need to be able=
 to tell when they were last > accessed?> > Carol> > -- > Sent via pgsql-ad=
min mailing list (pgsql-admin@postgresql.org)> To make changes to your subs=
cription:> http://www.postgresql.org/mailpref/pgsql-admin
_________________________________________________________________
Live Search premia tus b=FAsquedas=2C ll=E9vate hasta =A1Un Auto!
http://www.ganabuscando.com/Default.aspx=

--_53247eaf-24ed-46b6-a694-1b2ed0a88302_
Content-Type: text/html; charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<html>
<head>
<style>
.hmmessage P
{
margin:0px=3B
padding:0px
}
body.hmmessage
{
font-size: 10pt=3B
font-family:Verdana
}
</style>
</head>
<body class=3D'hmmessage'>
In postgresql.conf you can enable connections logs. log_connections =3D on<=
BR><BR>
<BR>&gt=3B From: walterc@indiana.edu<BR>&gt=3B To: pgsql-admin@postgresql.o=
rg<BR>&gt=3B Subject: [ADMIN] User info?<BR>&gt=3B Date: Wed=2C 3 Dec 2008 =
10:30:22 -0500<BR>&gt=3B <BR>&gt=3B Is there a way to tell when the last ti=
me a database in a cluster was <BR>&gt=3B accessed? I have a large number o=
f student databases that are <BR>&gt=3B probably inactive=2C but I don't wa=
nt to just destroy. I'd like to <BR>&gt=3B archive these=2C but I need to b=
e able to tell when they were last <BR>&gt=3B accessed?<BR>&gt=3B <BR>&gt=
=3B Carol<BR>&gt=3B <BR>&gt=3B -- <BR>&gt=3B Sent via pgsql-admin mailing l=
ist (pgsql-admin@postgresql.org)<BR>&gt=3B To make changes to your subscrip=
tion:<BR>&gt=3B http://www.postgresql.org/mailpref/pgsql-admin<BR><BR><br /=
><hr />Conoce el perfil completo de todos tus amigos de Windows Live Messen=
ger justo aqu=ED: <a href=3D'http://home.services.spaces.live.com/' target=
=3D'_new'>Windows Live Spaces</a></body>
</html>=

--_53247eaf-24ed-46b6-a694-1b2ed0a88302_--