X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 7320F3A4BDC for ; Fri, 21 Jan 2005 16:16:58 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 43387-01 for ; Fri, 21 Jan 2005 16:16:42 +0000 (GMT) Received: from mail.deg.cc (mail.deg.cc [64.139.134.201]) by svr1.postgresql.org (Postfix) with ESMTP id 8AFE73A1A99 for ; Fri, 21 Jan 2005 16:15:29 +0000 (GMT) Received: from deg.cc (kyle.deg.cc [198.70.16.205]) by mail.deg.cc (Postfix) with ESMTP id D3E375601A for ; Fri, 21 Jan 2005 11:15:23 -0500 (EST) Message-ID: <41F12A9D.6050706@deg.cc> Date: Fri, 21 Jan 2005 11:15:25 -0500 From: Pallav Kalva User-Agent: Mozilla/5.0 (X11; U; Linux i686; en-US; rv:1.4.2) Gecko/20040308 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Postgres 8.0 Log Configuration Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.05 tagged_above=0 required=5 tests=FORGED_RCVD_HELO X-Spam-Level: X-Archive-Number: 200501/236 X-Sequence-Number: 16095 Hi, Whenever i start my postgres 8 server i do "pg_ctl restart -D /var/lib/pgsql/data -l /var/log/postgresql/postmaster" where /var/log/postgresql/ is the dir and postmaster is the output log file for all postgres logging and errors. This above command works fine and logs all the postgres related messages into the specified filename. But I dont want to specify the "-l /var/log/postgresql/postmaster" option everytime I start the postmaster. I want to set the logfile name in the postgresql.conf file, i used the following setting : log_destination = 'syslog,stderr' redirect_stderr = true log_directory = '/var/lib/pgsql/' log_filename = 'postmaster.log' But still whenever i start my postgres server some of the messages are not logged into the specified logfile name in the postgresq.conf file and it is printing the log messages on the command line like this : $ pg_ctl restart -m f -D /var/lib/pgsql/data -o "-p 5432" waiting for postmaster to shut down....2005-01-21 10:37:13 EST%% LOG: logger shutting down done postmaster stopped postmaster starting $ 2005-01-21 10:37:15 EST%% LOG: could not create IPv6 socket: Address family not supported by protocol I want all the postgres related messages to be logged into the file in "log_filename" parameter specified in postgresql.conf . I tried changing "log_destination" parameter to syslog only or stderr only but still no change. am I missing something here ? or this is not possible with the postgresql.conf Thanks in advance. Pallav