Re: pg_connect() error

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/


-- 
Sent via pgsql-php mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php