Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id A4D2E1337B82 for ; Thu, 7 Apr 2011 14:35:53 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 18343-08 for ; Thu, 7 Apr 2011 17:35:43 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from salmo.appl-ecosys.com (appl-ecosys.com [216.99.206.23]) by mail.postgresql.org (Postfix) with ESMTP id E5F391337B93 for ; Thu, 7 Apr 2011 14:35:42 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id 4FA6537BC6; Thu, 7 Apr 2011 10:35:42 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id 4683837B42 for ; Thu, 7 Apr 2011 10:35:42 -0700 (PDT) Date: Thu, 7 Apr 2011 10:35:42 -0700 (PDT) From: Rich Shepard To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 In-Reply-To: <20110407132029.be595363.wmoran@potentialtech.com> Message-ID: References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> User-Agent: Alpine 2.00 (LNX 1167 2008-08-23) MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII; format=flowed X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.91 tagged_above=-10 required=5 tests=BAYES_00=-1.9, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201104/10 X-Sequence-Number: 4172 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