Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search archives
  Advanced Search

pg_connect fails, pgsql works


  • From: John Cartwright <John(dot)C(dot)Cartwright(at)noaa(dot)gov>
  • To: pgsql-php(at)postgresql(dot)org
  • Subject: pg_connect fails, pgsql works
  • Date: Mon, 10 Mar 2008 11:37:51 -0600
  • Message-id: <47D571EF.8020408@noaa.gov> <text/plain>

Hello All,

I'm using php 5.1.6 on a RHEL 5 system connecting to a postgresql server version 8.2.3. I think that TCP connections are enabled correctly in the server's pg_hba.conf and I can successfully connect from the client using pgsql. However, trying to use pg_connect() w/ a call like:

$con = pg_connect("host='postgres1.ngdc.noaa.gov' port=5432 sslmode='allow' user='test' password='mypassword' dbname='test'")


fails saying:

Unable to connect to PostgreSQL server: could not connect to server: Permission denied\n\tIs the server running on host &quot;postgres1.ngdc.noaa.gov&quot; and accepting\n\tTCP/IP connections on port 5432?

I'm perplexed since I can connect w/ pgsql from the same workstation using the same database, user, password.

Can anyone help me out here?

Thanks!

-- john




Home | Main Index | Thread Index

Privacy Policy | About PostgreSQL
Copyright © 1996 – 2012 PostgreSQL Global Development Group