Re: Database Create Date

[Achilleas Mantzios <achill(at)matrix(dot)gatewaynet(dot)com>]

Στις Τρίτη 09 Ιανουάριος 2007 17:36, ο/η Andy Shellam (Mailing Lists) έγραψε:
> 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>"
>

I was able to find that in FreeBSD the -U in ls (1) does the job.
However i could not find any inode creation time related info for linux 
(ext3).
Anyone has any clue on that?

> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend

-- 
Achilleas Mantzios