Re: Enable debug logging

On 09/22/2014 02:49 AM, Bala krishna Devasani wrote:
> how to enable debug logging for postgresql.. can anyone provide steps to
> enable debug logging.

Not clear whether you are talking about the psqlodbc driver or the
Postgres server or both.

If its the driver then:

http://psqlodbc.projects.pgfoundry.org/docs/config.html

MyLog (C:\mylog_xxxx.log): Log debug messages to that file. This is good
for debugging problems with the driver.

If its the server then:

http://www.postgresql.org/docs/9.3/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHEN

Look at table 18.1 for the log levels.

>
>
> Thanks & Regards
> Balakrishna
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com