Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id E13901336FA7 for ; Thu, 7 Apr 2011 19:19:56 -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 87664-08 for ; Thu, 7 Apr 2011 22:19:49 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail1.hosting.digiweb.ie (mail1.hosting.digiweb.ie [89.234.64.49]) by mail.postgresql.org (Postfix) with SMTP id EE76913364DE for ; Thu, 7 Apr 2011 19:19:48 -0300 (ADT) Received: (qmail 30953 invoked by uid 399); 7 Apr 2011 22:19:48 -0000 Received: from unknown (HELO ?127.0.0.1?) (ray@teladesign.ie@109.77.239.78) by mail1.hosting.digiweb.ie with SMTP; 7 Apr 2011 22:19:48 -0000 X-Originating-IP: 109.77.239.78 Message-ID: <4D9E387F.4030600@iol.ie> Date: Thu, 07 Apr 2011 23:19:43 +0100 From: Raymond O'Donnell Reply-To: rod@iol.ie User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.1; en-GB; rv:1.9.2.15) Gecko/20110303 Lightning/1.0b2 Thunderbird/3.1.9 MIME-Version: 1.0 To: Rich Shepard CC: 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> <4D9DFAB2.2080902@consistentstate.com> <4D9E0B35.3060402@consistentstate.com> <4D9E210C.3080009@iol.ie> In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Antivirus: avast! (VPS 110407-1, 06/04/2011), Outbound message X-Antivirus-Status: Clean 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 X-Spam-Level: X-Archive-Number: 201104/28 X-Sequence-Number: 4190 On 07/04/2011 23:02, Rich Shepard wrote: > 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). Hi Rich, That is a bit odd. Yes, please do post the relevant bits of the .conf - clearer heads than mine may spot something. What platform are you on (maybe you said already, and I missed it)? How did you install PostgreSQL? > 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. I think you've already got all the diagnostics you're going to get from the PHP side of things... there are PHP functions to get the most recent error from the Postgres connection, but it sounds as though the connection isn't getting made in the first place (which of course negates my upthread guess about bytea... doh). Ray. -- Raymond O'Donnell :: Galway :: Ireland rod@iol.ie