Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

Next:From: Russell FrancisDate: 2007-02-02 14:40:39
Subject: Re: JDBC and arrays
Previous:From: Miroslav Ć ulcDate: 2007-02-02 09:31:39
Subject: Re: JDBC and arrays

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group