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 C89BD3A5D1D for ; Wed, 12 Jan 2005 16:33:57 +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 38561-10 for ; Wed, 12 Jan 2005 16:33:50 +0000 (GMT) Received: from rproxy.gmail.com (rproxy.gmail.com [64.233.170.196]) by svr1.postgresql.org (Postfix) with ESMTP id 98A5A3A5C45 for ; Wed, 12 Jan 2005 16:33:49 +0000 (GMT) Received: by rproxy.gmail.com with SMTP id i8so69188rne for ; Wed, 12 Jan 2005 08:33:49 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:user-agent:x-accept-language:mime-version:to:subject:content-type:content-transfer-encoding; b=q8WOAoAd8pZU523H/FeKf9LVGHc0l3GBflWqRswa60qI/gd5WShbuzxY4uZJMv116KG8OENUmDWrehAfjMbGzI6QER2eZzUdqJbarO2REuaIU47X7/XVOTDCNnErwtmaucAPfMWMFHEiVySNhUOoncsdm3a8JXjlM/oHkV+iJUc= Received: by 10.38.15.41 with SMTP id 41mr96942rno; Wed, 12 Jan 2005 08:33:48 -0800 (PST) Received: from ?192.168.3.4? ([81.182.248.121]) by smtp.gmail.com with ESMTP id 64sm1065293rna.2005.01.12.08.33.47; Wed, 12 Jan 2005 08:33:48 -0800 (PST) Message-ID: <41E5515E.5010307@gmail.com> Date: Wed, 12 Jan 2005 17:33:34 +0100 From: =?ISO-8859-2?Q?Sz=FBcs_G=E1bor?= User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: Migration of log features from 7.4 to 8.0 Content-Type: text/plain; charset=ISO-8859-2; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.259 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200501/84 X-Sequence-Number: 15943 Dear Gurus, Please show me to the right manual/discussion if my questions are already answered/solved. 1. DEBUG message level separation: In v7.3 there were the annoying DEBUG messages Start/CloseTransactCommand. In v7.4 you could eliminate them from user DEBUG messages by logging from DEBUG2 level. In v8.0.0rc4, they are back at DEBUG2 level. Is there a way to eliminate them AND keep user DEBUG messages (i.e. plpgsql's "RAISE DEBUG") 2. CONTEXTs and HINTs Looked up all the lines in postgresql.conf, but couldn't find the one to turn CONTEXT and HINT lines after notices or errors. They proved to be very useful, but can't make them be logged in v8. Is there a way? 3. redirect_stderr bogus? Activating redirect_stderr, setting log_dir, log_file and all the rotate params, it looked to me that all output the logger produced were 'db system ready' and 'shut down', and not even these lines appeared in the log file. May it be a bug, or simply the fact that a nonempty file already existed (from redirected stdout, as described above)< TIA, -- G.