pg.ddx.io  pgsql-php@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Raymond O'Donnell <rod@iol.ie>
To: Rich Shepard <rshepard@appl-ecosys.com>
Cc: pgsql-php@postgresql.org
Subject: Re: Connecting PHP-based Application to Postgres-9.0.3
Date: Thu, 07 Apr 2011 23:19:43 +0100
Message-ID: <4D9E387F.4030600@iol.ie> (raw)
In-Reply-To: <alpine.LNX.2.00.1104071458350.9169@salmo.appl-ecosys.com>
References: <alpine.LNX.2.00.1104070900530.397@salmo.appl-ecosys.com>
	<201104070920.37258@hal.medialogik.com>
	<alpine.LNX.2.00.1104070933460.397@salmo.appl-ecosys.com>
	<20110407125635.1ae13751.wmoran@potentialtech.com>
	<alpine.LNX.2.00.1104071014420.397@salmo.appl-ecosys.com>
	<20110407132029.be595363.wmoran@potentialtech.com>
	<alpine.LNX.2.00.1104071034090.397@salmo.appl-ecosys.com>
	<4D9DFAB2.2080902@consistentstate.com>
	<alpine.LNX.2.00.1104071152370.397@salmo.appl-ecosys.com>
	<4D9E0B35.3060402@consistentstate.com>
	<alpine.LNX.2.00.1104071305570.397@salmo.appl-ecosys.com>
	<alpine.LNX.2.00.1104071323400.397@salmo.appl-ecosys.com>
	<4D9E210C.3080009@iol.ie>
	<alpine.LNX.2.00.1104071458350.9169@salmo.appl-ecosys.com>

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



view thread (42+ messages)  latest in thread

Message-ID: <4D9E387F.4030600@iol.ie>
Permalink:  ../4D9E387F.4030600@iol.ie/
Also on:    postgresql.org/message-id/4D9E387F.4030600@iol.ie

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-php@postgresql.org
  Cc: rod@iol.ie, rshepard@appl-ecosys.com
  Subject: Re: Connecting PHP-based Application to Postgres-9.0.3
  In-Reply-To: <4D9E387F.4030600@iol.ie>
  References: <alpine.LNX.2.00.1104070900530.397@salmo.appl-ecosys.com> <201104070920.37258@hal.medialogik.com> <alpine.LNX.2.00.1104070933460.397@salmo.appl-ecosys.com> <20110407125635.1ae13751.wmoran@potentialtech.com> <alpine.LNX.2.00.1104071014420.397@salmo.appl-ecosys.com> <20110407132029.be595363.wmoran@potentialtech.com> <alpine.LNX.2.00.1104071034090.397@salmo.appl-ecosys.com> <4D9DFAB2.2080902@consistentstate.com> <alpine.LNX.2.00.1104071152370.397@salmo.appl-ecosys.com> <4D9E0B35.3060402@consistentstate.com> <alpine.LNX.2.00.1104071305570.397@salmo.appl-ecosys.com> <alpine.LNX.2.00.1104071323400.397@salmo.appl-ecosys.com> <4D9E210C.3080009@iol.ie> <alpine.LNX.2.00.1104071458350.9169@salmo.appl-ecosys.com> <4D9E387F.4030600@iol.ie>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox