Re: how to check the creation date of a postgres database? - Mailing list pgsql-admin

From Tom Lane
Subject Re: how to check the creation date of a postgres database?
Date
Msg-id 26305.1158935455@sss.pgh.pa.us
Whole thread Raw
In response to Re: how to check the creation date of a postgres database?  (Jim Nasby <jim@nasby.net>)
Responses Re: how to check the creation date of a postgres database?  ("Jim C. Nasby" <jim@nasby.net>)
List pgsql-admin
Jim Nasby <jim@nasby.net> writes:
> On Sep 20, 2006, at 11:45 AM, Jessica Richard wrote:
>> I would like to know when each of my databases were created.

> You're not the first person to ask for this, but it's still pretty
> unclear what the use-case for that info is (and without a decent use-
> case, it's pretty unlikely that this info will get stored).

If we did store it, it would presumably reflect the time of issuance of
CREATE DATABASE, which would mean it wouldn't survive a dump and reload
anyway (as the OP seems to be wishing for).

            regards, tom lane

pgsql-admin by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: The server lacks instrumentation functions
Next
From: J-Pro
Date:
Subject: Silent install - silent error