Re: how to check the creation date of a postgres database?

From: Chris Mair <chrisnospam(at)1006(dot)org>
To: Jessica Richard <rjessil(at)yahoo(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: how to check the creation date of a postgres database?
Date: 2006-09-20 17:02:40
Message-ID: 1158771761.18229.152.camel@ultra.home.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Aaron Bono 2006-09-20 17:48:03 Monitoring Connections
Previous Message Chris Mair 2006-09-20 17:00:46 Re: how to check the creation date of a postgres database?