Problem to connect from host via JDBC ...

From: <tsmets(at)brutele(dot)be>
To: "pgsql jdbc" <pgsql-jdbc(at)postgresql(dot)org>
Subject: Problem to connect from host via JDBC ...
Date: 2002-03-05 08:47:28
Message-ID: 024601c1c422$6375c800$6501a8c0@calvin
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message ludovic smadja 2002-03-05 09:17:48 is anyone use executeQuery with autogeneratedkeys function ?
Previous Message Yousry Abdallah 2002-03-05 07:48:40 Re: [JDBC] problem about postgresql and jdbc