Re: Database Create Date

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