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 448DBD1B193 for ; Mon, 31 May 2004 21:49:51 -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 95567-07 for ; Mon, 31 May 2004 21:49:51 -0300 (ADT) Received: from merk.caltech.edu (merk.caltech.edu [131.215.15.23]) by svr1.postgresql.org (Postfix) with ESMTP id B4648D1B33B for ; Mon, 31 May 2004 21:49:46 -0300 (ADT) Received: from 66.215.94.245 ([66.215.94.245]) by merk.caltech.edu with MailEnable WebMail; Mon, 31 May 2004 17:49:31 -0700 To: From: "Ian Lipsky" Subject: Re: determining when a database was created Date: Mon, 31 May 2004 16:49:31 -0800 Message-ID: X-Mailer: MailEnable Web Mail 1.1 Mime-version: 1.0 X-Read: 0 X-Virus-Scanned: by amavisd-new at postgresql.org X-Spam-Status: No, hits=0.3 tagged_above=0.0 required=5.0 tests=MIME_BOUND_NEXTPART, RCVD_IN_SORBS X-Spam-Level: Content-Type: text/plain; charset="ISO-8859-1" X-Archive-Number: 200405/343 X-Sequence-Number: 13659 How can i determine which directory contains the database files? there are a few databases. I though of doing that, but didnt know how to tell which directory belongs with which database. thanks ----- Original Message ----- From: Tom Lane To: Ian Lipsky Cc: pgsql-admin@postgresql.org Sent: Mon, 31 May 2004 00:37:40 -0400 Subject: Re: [ADMIN] determining when a database was created 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 ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org