Re: 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   |
+------------------------------+---------------------------------------------+