Yes, the subnet mask needs to be 255.255.255.255 and not 255.255.255.0.
thanks,
-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org
[mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Paul Thomas
Sent: April 9, 2004 12:14
To: pgsql-jdbc @ postgresql . org
Subject: Re: [JDBC] cannot connect to db from remote machine
On 09/04/2004 15:37 Rein Reezigt wrote:
> Hello all,
>
> I have a problem connecting to the postgres database from a remote
> machine. I wonder if I have missed something. The java client which uses
> jdbc times out when connecting to the remote db. The database is running
> on a redhat 9 linux machine and I connect from eclipse on a windows
> machine.
> I changed a line in postgresql.conf to:
>
> tcpip_socket = true
>
> and in pg_hba.conf I added a line
>
> host all all 192.168.1.102 255.255.255.0
> trust
>
> where 192.168.1.102 is my windows machine. The linux machine is ...103.
> I restarted the postmaster, but I cannot connect. Any ideas?
I think your netmask should be 255.255.255.255.
HTH
--
Paul Thomas
+------------------------------+--------------------------------------------
-+
| Thomas Micro Systems Limited | Software Solutions for
Business |
| Computer Consultants |
http://www.thomas-micro-systems-ltd.co.uk |
+------------------------------+--------------------------------------------
-+
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org