Обсуждение: cannot connect to db from remote machine
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
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