Guys..I don't hv access to the server directely. Is it possible to get the DB creation date from the system catalog.??
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Bruno Wolff III Sent: Wednesday, January 10, 2007 2:16 PM To: Andy Shellam (Mailing Lists) Cc: pgsql-admin@postgresql.org Subject: Re: [ADMIN] Database Create Date On Wed, Jan 10, 2007 at 19:39:09 +0000, "Andy Shellam (Mailing Lists)" <[EMAIL PROTECTED]> wrote: > >I thought it was as well to begin with - but in "ls" on Linux there's > >a separate "atime" and "access" value to the "show time" parameter in > >"ls" - so if "atime" is the last access time, what's "access" mean? atime includes at least reads of the file. I don't know if it also includes writes or stats. > Hmm ok just done a bit of experimenting on this - "atime" and "access" > show exactly the same information - "mtime" is an invalid value > according to my Fedora 5 system. Confused. mtime is the time you normally see, so there may not be a separate option for it on ls. ---------------------------(end of broadcast)--------------------------- TIP 7: You can help support the PostgreSQL project by donating at http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 3: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faq