Logging SQL queries
Tuesday, December 20th, 2005A note to myself about how to log SQL queries when using PostgreSQL. In postgresql.conf set the following parameters:
log_statement = true
syslog = 2
syslog_facility = ‘LOCAL0′
syslog_ident = ‘postgres’
The database will need to be restarted in order for the changes to have any effect. To view the SQL queries that are being executed, log in as root […]