Re: cannot connect to db from remote machine - Mailing list pgsql-jdbc

From Dave Cramer
Subject Re: cannot connect to db from remote machine
Date
Msg-id 1081526118.9274.391.camel@localhost.localdomain
Whole thread Raw
In response to cannot connect to db from remote machine  ("Rein Reezigt" <r.reezigt@chello.nl>)
List pgsql-jdbc
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


pgsql-jdbc by date:

Previous
From: James Robinson
Date:
Subject: Under what circumstances does PreparedStatement use stored plans?
Next
From: Barry Lind
Date:
Subject: Re: Connection Idle in transaction