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 16:07:50
Message-ID: 1158768470.18229.143.camel@ultra.home.lan
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


> \l and \l+ show only the database name, owner and description.
> select * from pg_database does not have date info, either.
>
> I would like to know when each of my databases were created.

The only solution I can think of is querying
select oid, datname from pg_database;
and then look up the timestamps of the corresponding directories
in $PGDATA/base.

Bye, Chris.

--

Chris Mair
http://www.1006.org

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tomeh, Husam 2006-09-20 16:29:47 Re: how to check the creation date of a postgres
Previous Message Jessica Richard 2006-09-20 15:45:09 how to check the creation date of a postgres database?