Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id F305D133798E for ; Thu, 7 Apr 2011 19:02:21 -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 57525-07 for ; Thu, 7 Apr 2011 22:02:14 +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 1142B13364DE for ; Thu, 7 Apr 2011 19:02:14 -0300 (ADT) Received: by salmo.appl-ecosys.com (Postfix, from userid 1000) id C2BB637BC6; Thu, 7 Apr 2011 15:02:13 -0700 (PDT) Received: from localhost (localhost [127.0.0.1]) by salmo.appl-ecosys.com (Postfix) with ESMTP id BA3C137B42 for ; Thu, 7 Apr 2011 15:02:13 -0700 (PDT) Date: Thu, 7 Apr 2011 15:02:13 -0700 (PDT) From: Rich Shepard To: pgsql-php@postgresql.org Subject: Re: Connecting PHP-based Application to Postgres-9.0.3 In-Reply-To: <4D9E210C.3080009@iol.ie> Message-ID: References: <201104070920.37258@hal.medialogik.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <20110407132029.be595363.wmoran@potentialtech.com> <4D9DFAB2.2080902@consistentstate.com> <4D9E0B35.3060402@consistentstate.com> <4D9E210C.3080009@iol.ie> 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/25 X-Sequence-Number: 4187 On Thu, 7 Apr 2011, Raymond O'Donnell wrote: > Have you located the Postgres log yet? ISTM that that's where you need to > be looking. Ray, Yes ... and no. I think that I turned on all the right switches in postgresql.conf, but the logging is displayed to stdout rather than to syslog. I have a /var/log/postgresql but that has a few entries from last December and nothing since. I can post the .conf file to learn what I set incorrectly (or didn't set when it should be). I also changed bytea_encoding to 'escape' from 'hex', stopped and restarted the postmaster, and there's no change. In C and python I'd be putting little stub code to print in the function with the problems so I can tell just where I am when it fails. I've no idea of how to do this in php, or where it would be appropriate to insert code to generate diagnostics. Thanks, Rich