Thread: pg_connect() error
hi guys,
Arun
we have a postgres db with a hosting company and have been trying to connect to. error is below.
Warning: pg_connect() [function.pg-connect]: Unable to connect to PostgreSQL server: could not connect to server: Connection refused Is the server running on host "pgdb1.host-ed.net" and accepting TCP/IP connections on port 3306?
from my trawling around google i have found that it could be related to the postgres.conf file and turning on tcpip sockets to true?? (i cannot view/edit any postgres conf files)
oh and those are the host/port details supplied by hosting provider
any help would be appreciated in pointing on the right path.
Cheers
Arun
Arun Oakley wrote: > hi guys, > > we have a postgres db with a hosting company and have been trying to > connect to. error is below. > *Warning*: pg_connect() [function.pg-connect > <http://hoopsgm.net/test/function.pg-connect>]: Unable to connect to > PostgreSQL server: could not connect to server: Connection refused Is > the server running on host "pgdb1.host-ed.net > <http://pgdb1.host-ed.net>" and accepting TCP/IP connections on port 3306? Port 3306 is usually mysql not postgres. Postgres (by default) uses 5432. > from my trawling around google i have found that it could be related to > the postgres.conf file and turning on tcpip sockets to true?? (i cannot > view/edit any postgres conf files) > oh and those are the host/port details supplied by hosting provider > > > any help would be appreciated in pointing on the right path. Make sure they know you want a postgres db, not mysql. Apart from that, if you can't view a postgres.conf file let alone change it, you need to raise a support issue with them to fix it. Do they allow remote connections to their database? Maybe they don't for security reasons. -- Postgresql & php tutorials http://www.designmagick.com/