X-Original-To: pgsql-admin-postgresql.org@postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id D24E79FA436 for ; Wed, 20 Sep 2006 13:52:58 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 90388-07 for ; Wed, 20 Sep 2006 13:52:49 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from web58307.mail.re3.yahoo.com (web58307.mail.re3.yahoo.com [68.142.236.160]) by postgresql.org (Postfix) with SMTP id 2CB219FB0D1 for ; Wed, 20 Sep 2006 13:52:50 -0300 (ADT) Received: (qmail 46865 invoked by uid 60001); 20 Sep 2006 16:52:48 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.com; h=Message-ID:Received:Date:From:Subject:To:Cc:In-Reply-To:MIME-Version:Content-Type:Content-Transfer-Encoding; b=ZR6gRmwVgd/BMgM42CQ0Z6cqEcq/vMUvapA2m6DnpGAWDO9YYpAmNbC9XPbAcoUsYPyGBFhVgrNxtrvdaArt0uk1r/T0D5/sTaxOkNBdBagu5dhDYyjeLu5QCEiFpKGkPvm/L/eOGLd9eG51NoX124FVaz9qxmCBMHYmmZhoFeA= ; Message-ID: <20060920165248.46863.qmail@web58307.mail.re3.yahoo.com> Received: from [129.165.226.2] by web58307.mail.re3.yahoo.com via HTTP; Wed, 20 Sep 2006 09:52:48 PDT Date: Wed, 20 Sep 2006 09:52:48 -0700 (PDT) From: Jessica Richard Subject: Re: how to check the creation date of a postgres database? To: Chris Mair Cc: pgsql-admin@postgresql.org In-Reply-To: <1158768470.18229.143.camel@ultra.home.lan> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="0-496019211-1158771168=:41913" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=3.791 tagged_above=0 required=5 tests=AWL, DNS_FROM_RFC_ABUSE, DNS_FROM_RFC_POST, DNS_FROM_RFC_WHOIS, HTML_30_40, HTML_MESSAGE X-Spam-Level: *** X-Archive-Number: 200609/212 X-Sequence-Number: 23126 --0-496019211-1158771168=:41913 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit It didn't seem to work.... I just checked one $PGDATA/base directory, they all have today's time stamp (9/20/06) around 6:00 am this morning, that was when my daily database dump cron job was running... thanks anyway Chris Mair wrote: > \l and \l+ show only the database name, owner and description. > select * from pg_database does not have date info, either. > > I would like to know when each of my databases were created. The only solution I can think of is querying select oid, datname from pg_database; and then look up the timestamps of the corresponding directories in $PGDATA/base. Bye, Chris. -- Chris Mair http://www.1006.org --------------------------------- How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. --0-496019211-1158771168=:41913 Content-Type: text/html; charset=iso-8859-1 Content-Transfer-Encoding: 8bit It didn't seem to work....

I just checked one $PGDATA/base directory,  they all have today's time stamp (9/20/06)  around 6:00 am this morning, that was when my daily database dump cron job was running...

thanks anyway



Chris Mair <chrisnospam@1006.org> wrote:

> \l and \l+ show only the database name, owner and description.
> select * from pg_database does not have date info, either.
>
> I would like to know when each of my databases were created.

The only solution I can think of is querying
select oid, datname from pg_database;
and then look up the timestamps of the corresponding directories
in $PGDATA/base.

Bye, Chris.


--

Chris Mair
http://www.1006.org



How low will we go? Check out Yahoo! Messenger’s low PC-to-Phone call rates. --0-496019211-1158771168=:41913--