pg_connect() error

am 04.09.2009 06:19:59 von Arun Oakley

--0016e64de80e32f52d0472b8d06f
Content-Type: text/plain; charset=ISO-8859-1

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]:
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

--0016e64de80e32f52d0472b8d06f
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable

hi guys,

we have a postgres db with a hosting company an=
d have been trying to connect to. error is below.

Apple-style-span" style=3D"font-family: 'Times New Roman'; font-siz=
e: medium; ">Warning: pg_connect() [ st/function.pg-connect">function.pg-connect]: Unable to connect to Post=
greSQL server: could not connect to server: Connection refused Is the serve=
r 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 cou=
ld be related to the postgres.conf file and turning on tcpip sockets to tru=
e?? (i cannot view/edit any postgres conf files)

oh and those are the host/port details supplied by hosting provider

iv>

any help would be appreciated in pointing =
on the right path.

Cheers

Arun

--0016e64de80e32f52d0472b8d06f--

Re: pg_connect() error

am 11.09.2009 00:51:14 von dmagick

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
> ]: 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?

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 (pgsql-php@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-php