Re: pg_connect fails, pgsql works
"F. Jovan Jester" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.php |
|---|---|
| Message-ID | <[email protected]> |
are you sure it's not some kind of firewall issue? can you post your pg_hba conf to make sure it's set up properly? Only other thing i can think of is to try changing the host to IP address form, in case there's some kind of DNS resolution problem. hope that helps, -Jovan On 3/10/08, John Cartwright <[email protected]> wrote: > > 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 > "postgres1.ngdc.noaa.gov" 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 > > > > -- > Sent via pgsql-php mailing list ([email protected]) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-php >