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: (view raw, whole thread or download thread mbox)
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 

(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-2017 The PostgreSQL Global Development Group