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