--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<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" 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,<div><br></div><div>we have a postgres db with a hosting company an=
d have been trying to connect to. error is below.</div><div><span class=3D"=
Apple-style-span" style=3D"font-family: 'Times New Roman'; font-siz=
e: medium; "><b>Warning</b>: pg_connect() [<a href=3D"http://hoopsgm.net/te=
st/function.pg-connect">function.pg-connect</a>]: Unable to connect to Post=
greSQL server: could not connect to server: Connection refused Is the serve=
r running on host "<a href=3D"http://pgdb1.host-ed.net">pgdb1.host-ed.=
net</a>" and accepting TCP/IP connections on port 3306?</span></div>
<div><br></div><div>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)</div><div><br></div><div>
oh and those are the host/port details supplied by hosting provider</div><d=
iv><br></div><div><br></div><div>any help would be appreciated in pointing =
on the right path.</div><div><br></div><div>Cheers</div><div><br>Arun</div>

--0016e64de80e32f52d0472b8d06f--

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