X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id E8E04D1B1AE for ; Mon, 31 May 2004 01:37:45 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 35276-08 for ; Mon, 31 May 2004 01:37:45 -0300 (ADT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 4C849D1B1DC for ; Mon, 31 May 2004 01:37:44 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.12.11/8.12.11) with ESMTP id i4V4beHS007025; Mon, 31 May 2004 00:37:41 -0400 (EDT) To: Ian Lipsky Cc: pgsql-admin@postgresql.org Subject: Re: determining when a database was created In-reply-to: <6.1.0.6.2.20040528175443.01ab1468@merk.caltech.edu> References: <6.1.0.6.2.20040528175443.01ab1468@merk.caltech.edu> Comments: In-reply-to Ian Lipsky message dated "Fri, 28 May 2004 17:56:17 -0700" Date: Mon, 31 May 2004 00:37:40 -0400 Message-ID: <7024.1085978260@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200405/333 X-Sequence-Number: 13649 Ian Lipsky writes: > is there a way to tell when a database was created? Nope, PG doesn't record that anywhere. You could get an upper bound by looking for the oldest file mod time in the database's files. This isn't completely reliable, but unless you're in the habit of changing system catalogs as obscure as pg_am, it'd probably be good enough. regards, tom lane