The "Connection Refused" message is actually coming from the TCP/IP
stack, rather than Java or JDBC. It's caused by nothing actually
listening on the remote socket.
With postgresql, this indicates that you haven't started the postmaster
with the -i flag, which enables the IP socket.
Peter
--
Peter Mount
Enterprise Support
Maidstone Borough Council
Any views stated are my own, and not those of Maidstone Borough Council.
-----Original Message-----
From: John Collins [mailto:jcollins@cs.umn.edu]
Sent: Friday, March 03, 2000 3:17 PM
To: pgsql-interfaces@postgreSQL.org
Subject: [INTERFACES] JDBC connection refused
I have Postgresql set up on RedHat 6.1, and I can access it with jdbc or
pgaccess locally, and with pgaccess from another linux box on the same
local net. However, I can't get a connection with jdbc across the net.
The relevant code is
public static void main (String[] args) { try { Class.forName("postgresql.Driver"); Connection con =
DriverManager.getConnection("jdbc:postgresql://birch/auction", "collins", ""); // Do something useful here
Statement stmt = con.createStatement(); ....
and the error message is
Connection refused. Check that the hostname and port is correct, and
that the postmaster is running with the -i flag, which enables TCP/IP
networking.at postgresql.Connection.openConnection(Connection.java, Compiled Code)
at postgresql.Driver.connect(Driver.java, Compiled Code)at java.sql.DriverManager.getConnection(DriverManager.java,
Compiled
Code)....
Here's what I've checked:- postmaster is indeed being run with the -i flag. I think neither the
local jdbc or the remote pgaccess would work otherwise. Here's the line
from rc.d/init.d/postgres: su -l postgres -c '/usr/bin/postmaster -i -S -D/var/lib/pgsql'- I've used every name I
canthink of, including the ip address, in the
URL above. I've used the port and I've not used the port.- I've used netstat to check that postmaster is indeed
listeningon
5432
I'm stumped. Thanks in advance for any assistance.
John Collins
University of Minnesota
************