How to enable logging of all SQL executed by PostgreSQL 8.3?
Edited (more info)
I changed these lines :
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
log_statement = 'all'
And restart PostgreSQL service… but no log was created…
I'm using Windows Server 2003.
Any ideas?
Best Answer
In your
data/postgresql.conf
file, change thelog_statement
setting to'all'
.Edit
Looking at your new information, I'd say there may be a few other settings to verify:
log_destination
variablelogging_collector
log_directory
directory already exists inside of thedata
directory, and that the postgres user can write to it.