Re: determining when a database was created - Mailing list pgsql-admin

From Tom Lane
Subject Re: determining when a database was created
Date
Msg-id 7024.1085978260@sss.pgh.pa.us
Whole thread Raw
In response to determining when a database was created  (Ian Lipsky <postgres@merk.caltech.edu>)
List pgsql-admin
Ian Lipsky <postgres@merk.caltech.edu> 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

pgsql-admin by date:

Previous
From: Tom Lane
Date:
Subject: Re: Backend crash
Next
From: "Paul Gimpelj"
Date:
Subject: [admin]@postgresql.org pg_database contents ... what happens