i have a problem connecting to postgres using the jdbc driver.
took the org.postgresql.test.jdbc2.DriverTest and modified it to use
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.
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
pgsql-jdbc by date
|Next:||From: Andreas Joseph Krogh||Date: 2007-02-01 15:32:43|
|Subject: Any reason for PSQLState not to be Serializable?|
|Previous:||From: Jeffrey Cox||Date: 2007-02-01 11:19:51|
|Subject: getArray and char - patches|