Thread: cannot connect to db from remote machine

on the running machine

try netstat -nlp | grep 5432

if that shows the connection as a tcp/ip

then try telnet <machine> 5432

Dave
On Fri, 2004-04-09 at 10: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?
>
> Regards,
>
> Rein
>
--
Dave Cramer
519 939 0336
ICQ # 14675561

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

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