| 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: | Whole Thread | Raw Message | 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 |