Re: Problem to connect from host via JDBC ... - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: Problem to connect from host via JDBC ...
Date
Msg-id 005301c1c448$b14800e0$8201a8c0@inspiron
Whole thread Raw
In response to Problem to connect from host via JDBC ...  (<tsmets@brutele.be>)
List pgsql-jdbc
Thomas,

Can you send me the results of netstat -nlp | grep 5432

Dave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of tsmets@brutele.be
Sent: Tuesday, March 05, 2002 3:47 AM
To: pgsql jdbc
Subject: [JDBC] Problem to connect from host via JDBC ...




I configured the postgres DB to start with :
    /usr/bin/postmaster -o -i -D ${PGDATA}
which I manually start with the "-d 5 & "@ the end.

The "psql" commands works fine locally.

pg_hda.conf contains the following line :
# The same, over Unix-socket connections:
#
#  local  all     192.168.1.0     255.255.255.0   trust
 host   all     192.168.1.0     255.255.255.0   trust

Of course my network is 192.168.1.0 with a subnetmask of 255.255.255.0

Trying to connect from another machine via JDBC gives the following
error: "1109 [main] WARN org.test.JDBCPostgres.TestJDBCPostgres  -
Message: 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."

Which is definitevely the case :
$ ps -ef | grep post
    postgres  6525  6456  0 14:40 pts/0    00:00:00
/usr/bin/postmaster -o -i -D /da

Does some one knows what is going wrong ?

Thomas,

--
Thomas SMETS
rue J. Wytsmanstraat 62
1050 Bruxelles
yahoo-id: smetsthomas






---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org



pgsql-jdbc by date:

Previous
From: "Dave Cramer"
Date:
Subject: Re: Numeric decimal digits and radix to DatabaseMetaData.getColumns()
Next
From: "Dave Cramer"
Date:
Subject: Re: is anyone use executeQuery with autogeneratedkeys function ?