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: pgsql-admin-owner@postgresql.org
[mailto:pgsql-admin-owner@postgresql.org] 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)" <andy.shellam-lists@mailnetwork.co.uk>
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