How to log PostgreSQL queries?

postgresql logging
Paul picture Paul · Apr 6, 2009 · Viewed 423.7k times · Source

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?

Answer

Jarret Hardie picture Jarret Hardie · Apr 6, 2009

In your data/postgresql.conf file, change the log_statement setting to 'all'.

Edit

Looking at your new information, I'd say there may be a few other settings to verify:

  • make sure you have turned on the log_destination variable
  • make sure you turn on the logging_collector
  • also make sure that the log_directory directory already exists inside of the data directory, and that the postgres user can write to it.

Related questions

Where are the PostgreSQL logs on macOS?

I would like to take a look at the PostgreSQL log files to see what my app writes to them but I can't find them. Any ideas?

Read More
How can I use a PostgreSQL triggers to store changes (SQL statements and row changes)

Using PostgreSQL triggers, is it possible to record the changes that have happened to a table due to INSERT or UPDATE SQL statements and log them to a file for later execution. This is only to be used temporally so …

Read More
PostgreSQL how to find any changes in the last n-minutes

I am writing a program that syncs PostgreSQL and MS SQL server databases (and adds some changes in this transition). With multi million records, it takes a long time, and loads server pretty bad with select *; it also takes more …

Read More