Is there a way to determine when a DB was created (create database...)?
Thanks in advance.
2012/9/17 Gauthier, Dave dave.gauth...@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] GUC to log DDL statements.
Regards,
[1]
On Mon, Sep 17, 2012 at 2:16 PM, Gauthier, Dave dave.gauth...@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