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 BFE758B9BD0 for ; Fri, 4 Feb 2005 21:47:40 +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 49453-10 for ; Fri, 4 Feb 2005 21:47:30 +0000 (GMT) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.187]) by svr1.postgresql.org (Postfix) with ESMTP id B07D18B9B57 for ; Fri, 4 Feb 2005 21:47:30 +0000 (GMT) Received: from [212.227.126.206] (helo=mrelayng.kundenserver.de) by moutng.kundenserver.de with esmtp (Exim 3.35 #1) id 1CxBIY-0003uJ-00 for pgsql-admin@postgresql.org; Fri, 04 Feb 2005 22:47:30 +0100 Received: from [192.59.128.130] (helo=stromboli) by mrelayng.kundenserver.de with asmtp (Exim 3.35 #1) id 1CxBIY-0000QQ-00 for pgsql-admin@postgresql.org; Fri, 04 Feb 2005 22:47:30 +0100 From: "Simon Riggs" To: Subject: log_duration Date: Fri, 4 Feb 2005 12:47:20 -0800 Message-ID: MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO, Build 9.0.2416 (9.0.2911.0) X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700 Importance: Normal X-Provags-ID: kundenserver.de abuse@kundenserver.de auth:51320d06ba6b43864a3fe5d428030dbe X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.032 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200502/39 X-Sequence-Number: 16207 On top of a confusing day, I now have this: I set log_duration = true in a postgresql.conf file. I startup and test, local users connected via psql: working, no problem. Users connecting remotely, same user, same database: no log of query statement durations. There is nothing in the code that sets this value independently for sets of users (is there?) I'm also having similar problems with log_min_statement_duration not working at all. Any ideas? Thanks, Best Regards, Simon Riggs