when was a db/schema created ?

2012/9/17 Gauthier, Dave <dave.gauthier@intel.com>

Is there a way to determine when a DB was created (create database...)?**
**

Thanks in advance.****

Dear Dave,

You can configure the "log_statement" [1]http://www.postgresql.org/docs/current/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT GUC to log DDL statements.

Regards,

[1]: http://www.postgresql.org/docs/current/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT
http://www.postgresql.org/docs/current/interactive/runtime-config-logging.html#GUC-LOG-STATEMENT

--
Fabrízio de Royes Mello
Consultoria/Coaching PostgreSQL

On Mon, Sep 17, 2012 at 2:16 PM, Gauthier, Dave <dave.gauthier@intel.com> wrote:

Is there a way to determine when a DB was created (create database...)?

If you don't have the CREATE DATABASE statement in your logs, you could try

SELECT oid FROM pg_database WHERE datname = 'name of your database';

Then check the creation time of the directory with that OID in your
$PGDATA directory, under ./base/.

Josh