On 11-04-13 12:37 PM, Kevin Grittner wrote:
Eric Comeau<ecom...@signiant.com> wrote:
We currently have statement timeout set
statement_timeout = 10800000 # 3 hrs
and we receive the following in the postgresql.log
[1-1] ERROR: canceling statement due to statement timeout
Is there a way to have the SQL statement logged as well?
log_min_error_statement = 'ERROR'
-Kevin
This solved the problem. Thanks Kevin.
I was surprised to discover that the default for log_min_error_statement
is PANIC on 8.1, it appears they have changed the default from 8.2+ to
ERROR now.
Eric
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin