pobox@xxxxxxxxxxxxx wrote:
Richard Huxton wrote:
pobox@xxxxxxxxxxxxx wrote:
What other variable (which are sometimes there, sometimes not)
reasons there can be pg_connect to fail?
What result-code/error do you get? What do your logs show?
I have -
$connection = pg_connect("$host $db $user $pass");
When I get the error it is because $connection is 'false'.
Thought of using pg_result_error - but it seems applicable only to
queries (i.e. with pg_query or pg_execute). How can I get an error code?
Did you try pg_last_error()?
PostgreSQL is instructed to log into the syslog, which is
/var/log/messages. There are only two type of things there from today -
[1-1] WARNING: nonstandard use of \\ in a string literal at character XXX
[1-2] HINT: Use the escape string syntax for backslashes, e.g., E'\\'.
But it does not seem like any of these are related to pg_connect, or am
I wrong (I guess they are related to bad code somewhere).
Are you logging connection attempts/failures? Details in the manuals.
--
Richard Huxton
Archonet Ltd
