Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id D81AC1337BF2 for ; Thu, 7 Apr 2011 15:00:28 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 52814-05 for ; Thu, 7 Apr 2011 18:00:21 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-vx0-f174.google.com (mail-vx0-f174.google.com [209.85.220.174]) by mail.postgresql.org (Postfix) with ESMTP id E837A1337BEC for ; Thu, 7 Apr 2011 15:00:20 -0300 (ADT) Received: by vxi39 with SMTP id 39so2144761vxi.19 for ; Thu, 07 Apr 2011 11:00:20 -0700 (PDT) Received: by 10.52.161.105 with SMTP id xr9mr1703550vdb.193.1302198900766; Thu, 07 Apr 2011 10:55:00 -0700 (PDT) Received: from sidon.consistentstate.com (173-164-51-9-colorado.hfc.comcastbusiness.net [173.164.51.9]) by mx.google.com with ESMTPS id h18sm1093762vbr.16.2011.04.07.10.54.58 (version=SSLv3 cipher=OTHER); Thu, 07 Apr 2011 10:54:59 -0700 (PDT) Message-ID: <4D9DFAB2.2080902@consistentstate.com> Date: Thu, 07 Apr 2011 11:56:02 -0600 From: Brian Fehrle User-Agent: Mozilla/5.0 (X11; U; Linux i686 (x86_64); en-US; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9, RCVD_IN_DNSWL_NONE=-0.0001 X-Spam-Level: X-Archive-Number: 201104/13 X-Sequence-Number: 4175 In the postgresql.conf file, look for these parameters. log_destination (can be set to stderr, csvlog, syslog, and eventlog, you probably want syslog). log_connections (default is off, turn this on to see all connection attempts to the database) log_disconnections (same as log_connections) These should let you see the connection information from the perspective of the database. - Brian F Consistent State On 04/07/2011 11:35 AM, Rich Shepard wrote: > On Thu, 7 Apr 2011, Bill Moran wrote: > >> Check the PG server logs, and consider increasing some logging levels on >> the server. PG does some pretty good logging of failed connections >> if you >> have the settings right. > > Bill, > > There was no logging. I looked at /usr/local/pgsql/data/postgresql.conf > and had no idea what should be changed (and to what values) to enable > appropriate logging to /var/log/messages (where syslog messages go). > Please > advise. > > Thanks, > > Rich >