Received: from localhost (maia-3.hub.org [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 054639FA3AC for ; Tue, 9 Jan 2007 12:04:56 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-new, port 10024) with ESMTP id 72489-04 for ; Tue, 9 Jan 2007 12:04:16 -0400 (AST) X-Greylist: from auto-whitelisted by SQLgrey-1.7.4 Received: from matrix.gatewaynet.com (host2.dynacom.ondsl.gr [62.103.35.210]) by postgresql.org (Postfix) with ESMTP id 9D2F89F931E for ; Tue, 9 Jan 2007 12:04:16 -0400 (AST) Received: from host3.dynacom.ondsl.gr ([62.103.35.211] helo=ip216.internal.net) by matrix.gatewaynet.com with esmtp (Exim 4.62) (envelope-from ) id 1H4JSP-0001eJ-Pq for pgsql-admin@postgresql.org; Tue, 09 Jan 2007 18:04:13 +0200 From: Achilleas Mantzios Organization: Dynacom Tankers Mgmt To: pgsql-admin@postgresql.org Subject: Re: Database Create Date Date: Tue, 9 Jan 2007 18:04:13 +0200 User-Agent: KMail/1.9.3 References: <45A3B67F.30209@mailnetwork.co.uk> In-Reply-To: <45A3B67F.30209@mailnetwork.co.uk> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-7" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200701091804.13499.achill@matrix.gatewaynet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200701/74 X-Sequence-Number: 24230 =D3=F4=E9=F2 =D4=F1=DF=F4=E7 09 =C9=E1=ED=EF=F5=DC=F1=E9=EF=F2 2007 17:36, = =EF/=E7 Andy Shellam (Mailing Lists) =DD=E3=F1=E1=F8=E5: > Negandhi, Nishith wrote: > > Hi, > > I need to know the create date of databases on PosegreSQL. > > PG_DATABASE does not provide this information. > > Are there any other system catalogs that can provide the above > > information?? > > > > Thanks > > !DSPAM:37,45a3b385137101969839670! > > I'm sure there is (not known to me atm), but for a quick shot you could > find the DB's "OID" from pg_database and look at the create date of " data dir>/base/" > I was able to find that in FreeBSD the -U in ls (1) does the job. However i could not find any inode creation time related info for linux=20 (ext3). Anyone has any clue on that? > ---------------------------(end of broadcast)--------------------------- > TIP 6: explain analyze is your friend =2D-=20 Achilleas Mantzios