Στις Τρίτη 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
