Re: Connecting PHP-based Application to Postgres-9.0.3
|[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]|
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@xxxxxx