logging how to add timestamp - Mailing list pgsql-admin

From Campbell, Lance
Subject logging how to add timestamp
Date
Msg-id B75CD08C73BD3543B97E4EF3964B7D70045E24@CITESMBX2.ad.uillinois.edu
Whole thread Raw
Responses Re: logging how to add timestamp  (Ray Stell <stellr@cns.vt.edu>)
List 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

 

pgsql-admin by date:

Previous
From: "Kevin Grittner"
Date:
Subject: Re: Reindexing primary keys without locking
Next
From: Ray Stell
Date:
Subject: Re: logging how to add timestamp