Re: pg_connect sometimes works sometimes not

pobox(at)verysmall(dot)org wrote:
> Richard Huxton wrote:
>> pobox(at)verysmall(dot)org 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