PostgreSQL error

[Russell.Wood]

Hi All,

When I try to connect to a PostgreSQL database running locally using PHP I get the following error:

"Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not get socket error status: No such file or directory in <script>"

The error that appears in the postgresql log is:

"LOG: incomplete startup packet"

I can connect to the database using pgAdmin III.

I have tried to connect to the database locally and via TCP/IP. I can connect locally using psql command.

Any advise is appreciated.

[Mel Burslan]

Not a postgres expert here but are you sure your networking information is correct ? Is your database listener running and listening to the port your PHP application is trying to access to ?

[Russell.Wood]

Yes. As I said, I can connect to it from my PC using pgAdmin (and telnet) plus I can connect locally with psql (like sqlplus for the Oracle folk). It's only when PHP connects it gets the strange error.

[Eric Antunes]

Hi Russell,

Check this forum:

http://forums.devshed.com/postgresql-help-21/pg-connect-unable-to-connect-to-postgresql-server-48639.html

Best Regards,

Eric Antunes

[Russell.Wood]

Like I said. I'm able to connect to it via TCP/IP and locally.

[Marcel S. Gongora]

Hello Russell.Wood,
I have exactly the same problem and after trying many solutions, I came to the conclusion that the problem is the PHP module for postgre.
I hosted my website on another server with Debian and everything seems to work. In this test the web application connects to the POSTGRE on HP-UX.
I tested with the PHP of the HP-UX Apache-based Web Server version B.2.2.8.04 and B.2.0.59.02.
I trying with POSTGRE 8.1.17 compiled by myself, 8.2.5 and 8.3.7 both binary from iexpress DVD.
Who else can I do to solve this problem??