logging how to add timestamp

From: "Campbell, Lance" <lance(at)illinois(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: logging how to add timestamp
Date: 2011-06-01 16:56:12
Message-ID: B75CD08C73BD3543B97E4EF3964B7D70045E24@CITESMBX2.ad.uillinois.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Postgresql: 8.4.x
How do you add a timestamp to the logs. Currently I see:

ERROR: {some error message}
STATEMENT: {the sql statement}

Ideally I would like to have the timestamp in front of the statements.

Thanks,

Lance Campbell
Software Architect/Project Manager/DBA
Web Services at Public Affairs
217.333.0382
http://illinois.edu/toolbox

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ray Stell 2011-06-01 17:17:45 Re: logging how to add timestamp
Previous Message Kevin Grittner 2011-06-01 13:52:00 Re: Reindexing primary keys without locking