From: | Nico Grubert <nicogrubert(at)gmail(dot)com> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Logging in postgresql.conf - no SQL statements are logged |
Date: | 2006-11-10 09:48:12 |
Message-ID: | 45544ADC.20509@gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Dear list members,
I would like to enable logging and write every SQL command that is
executed in a logfile so I modified the "postgresql.conf" file in order
to log everything. I restarted the Postgres SQL server. Unfortunately,
no SQL statements are logged in the logfile.
Here is a snippet of my postgresql.conf:
#---------------------------------------------------------------------------
# ERROR REPORTING AND LOGGING
#---------------------------------------------------------------------------
# - Where to Log -
log_destination = 'stderr'
# This is used when logging to stderr:
redirect_stderr = true
# These are only used if redirect_stderr is on:
log_directory = '/data/pgsql/log'
log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'
#log_truncate_on_rotation = off
log_rotation_age = 1440
#log_rotation_size = 10240
# These are relevant when logging to syslog:
#syslog_facility = 'LOCAL0'
#syslog_ident = 'postgres'
# - When to Log -
#client_min_messages = notice
...
#---------------------------------------------------------------------------
# RUNTIME STATISTICS
#---------------------------------------------------------------------------
Did I miss something?
Kind regards,
Nico
From | Date | Subject | |
---|---|---|---|
Next Message | A. Kretschmer | 2006-11-10 10:00:17 | Re: Logging in postgresql.conf - no SQL statements are logged |
Previous Message | Enrico | 2006-11-10 08:24:58 | Re: Linux vs. FreeBSD |