Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9A2CD9FB397 for ; Mon, 2 Oct 2006 12:04:19 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 89110-05 for ; Mon, 2 Oct 2006 12:04:15 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey- Received: from mail.livedatagroup.com (mail.livedatagroup.com [64.139.134.201]) by postgresql.org (Postfix) with ESMTP id 108F79FB2D8 for ; Mon, 2 Oct 2006 12:04:14 -0300 (ADT) Received: by mail.livedatagroup.com (Postfix, from userid 10003) id 5E4BE2A1789; Mon, 2 Oct 2006 11:04:13 -0400 (EDT) Received: from [192.168.2.134] (adsl-074-228-048-194.sip.bct.bellsouth.net [74.228.48.194]) by mail.livedatagroup.com (Postfix) with ESMTP id CD5232A5114 for ; Mon, 2 Oct 2006 11:04:11 -0400 (EDT) Message-ID: <45212A6B.2060503@livedatagroup.com> Date: Mon, 02 Oct 2006 11:04:11 -0400 From: Pallav Kalva User-Agent: Thunderbird 1.5.0.7 (X11/20060911) MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Postgres Logging doesnt work Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200610/3 X-Sequence-Number: 23306 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.