Re: jdbc connection problem

From: David Buchmann <david(at)mediagonal(dot)ch>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: jdbc connection problem
Date: 2007-02-02 10:30:17
Message-ID: 45C312B9.5000107@mediagonal.ch
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-jdbc

thanks a lot. Ubuntu 6.10 sets the port to 5433 instead of 5432.
psql seems to consider this when not specifying a port - jdbc not.

i changed the port setting in /etc/postgresql/8.1/main/postgresql.conf
to 5432 and stopped postgres and started it new. now jdbc gets the
connection.

(restart / reload did not change the port.)

Kris Jurka wrote:
>
>
> 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
>
> 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
>>

In response to

Browse pgsql-jdbc by date

  From Date Subject
Next Message Russell Francis 2007-02-02 14:40:39 Re: JDBC and arrays
Previous Message Miroslav Šulc 2007-02-02 09:31:39 Re: JDBC and arrays