Logging in postgresql.conf - no SQL statements are logged
От | Nico Grubert |
---|---|
Тема | Logging in postgresql.conf - no SQL statements are logged |
Дата | |
Msg-id | 45544ADC.20509@gmail.com обсуждение исходный текст |
Ответы |
Re: Logging in postgresql.conf - no SQL statements are logged
|
Список | 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
В списке pgsql-general по дате отправления: