Search Postgresql Archives

Re: just an inconvenience, or.... : failed queries don't appear in the log anymore since v8.?.?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 




On Dec 28, 2005, at 9:46 AM, Frank van Vugt wrote:

I may be overlooking some option here, but somewhere between the v7 series and the current v8.1.1 that I'm using, failed queries stopped being logged, only the error message appears in the log (config option log_statement = all).

I.e. executing

	select 1 2;

will result in just the logging of

	ERROR:  syntax error at or near "2" at character 10


You want to set

log_min_error_statement = error


in your postgresql.conf file. The default value of 'panic' seems less than useful to me.



[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux