Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Postgres Logging doesnt work



Hi ,

    My production database stopped writting to the postgres log files
all of a sudden, does anybody know why ?

   Database seems to run fine.

    Postgres version is 8.0.2

   Here are my settings

 log_connections                | off
 log_destination                | stderr
 log_directory                  | /var/lib/pgsql/pg_log
 log_disconnections             | off
 log_duration                   | off
 log_error_verbosity            | default
 log_executor_stats             | off
 log_filename                   | postgresql-%U.log
 log_hostname                   | off
 log_line_prefix                | %t%%%r%%%u%%%d
 log_min_duration_statement     | 30000
 log_min_error_statement        | panic
 log_min_messages               | notice
 log_parser_stats               | off
 log_planner_stats              | off
 log_rotation_age               | 10080
 log_rotation_size              | 0
 log_statement                  | ddl
 log_statement_stats            | off
 log_truncate_on_rotation       | on
 syslog_facility                | LOCAL0
 syslog_ident                   | postgres


Thanks!
Pallav.



Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group