Re: how to check the creation date of a postgres database? - Mailing list pgsql-admin

From Chris Mair
Subject Re: how to check the creation date of a postgres database?
Date
Msg-id 1158771761.18229.152.camel@ultra.home.lan
Whole thread Raw
In response to Re: how to check the creation date of a postgres database?  (Jessica Richard <rjessil@yahoo.com>)
List pgsql-admin
> Thanks, but I still can't get the database creation date....
>
>
> % cat PG_VERSION
> 8.1
>
> 16% ls -lt PG*
> -rw-------    1 postgres users          4 Jun 22 10:34 PG_VERSION
>
> This date was the date that the Postgres server was upgraded to 8.1
> and the timestamp of this file is same under each of all database
> directories....

Ah, then the information was lost when you upgraded :/

Backups of the data files prior to the upgrade?

Bye, Chris.




pgsql-admin by date:

Previous
From: Chris Mair
Date:
Subject: Re: how to check the creation date of a postgres database?
Next
From: "Aaron Bono"
Date:
Subject: Monitoring Connections