Re: Database Create Date

From: "Andy Shellam (Mailing Lists)" <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk>
To: "Negandhi, Nishith" <Nishith(dot)Negandhi(at)infoUSA(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: Database Create Date
Date: 2007-01-09 15:36:31
Message-ID: 45A3B67F.30209@mailnetwork.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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 "<pg
data dir>/base/<db oid>"

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Negandhi, Nishith 2007-01-09 15:46:41 Re: Database Create Date
Previous Message Negandhi, Nishith 2007-01-09 15:22:49 Database Create Date