Re: Problem getting a connection with Postgres 8.0.3

On Wed, 28 Sep 2005, Pedro Mendes wrote:

> I'm having some problems connecting my jsp application using driver
> postgresql-8.0-312.jdbc3 to a local postgresql database server. The
> connection seems to be always refused whatever the user and/or database.
>
> DriverManager.getConnection("jdbc:postgresql://192.168.8.2/cgm","cgm","esper
> anca");
>
> Message: Connection refused. Check that the hostname and port are correct
> and that the postmaster is accepting TCP/IP connections.
>

This is a tcpip error message, caused by the server not listening on the
desired port. What have you set listen_addresses in postgresql.conf?
Probably only localhost. Try adding the server's external address or * to
listen on all available addresses.

Kris Jurka