Re: jdbc connection problem

On Thu, 1 Feb 2007, david(at)mediagonal(dot)ch wrote:

> i have a problem connecting to postgres using the jdbc driver.
>
> String url = "jdbc:postgresql://localhost/testdb";
> String user = "username";
> String pass = "password";
>
>
> i get the exception org.postgresql.util.PSQLException: Connection
> Refused. Check that the hostname and port are correct and that the
> postmaster is accepting TCP/IP connections.
>
> however, using psql -h localhost -U username -W and then specifying the
> password works. so i do not see how this could be a general problem with
> postgresql listening on the wrong interface or not accepting connections
> from the local host.
>
> btw, i use psql 8.1.4 on ubuntu, jdbc is postgresql-8.1-408.jdbc2.jar
>

Debian variants often have multiple servers installed on multiple ports.
Try adding explicit port numbers to both psql and jdbc connections to
ensure that you're getting the same thing.

Kris Jurka