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
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 |