Re: Connection Problem - Mailing list pgsql-jdbc

From Rob Stone
Subject Re: Connection Problem
Date
Msg-id 1291900691.3402.7.camel@roblaptop.localdomain
Whole thread Raw
In response to Re: Connection Problem  (Oliver Jowett <oliver@opencloud.com>)
Responses Re: Connection Problem
List pgsql-jdbc
Hi Oliver,

Thanks for the reply.

Output from netstat shows port 5432 as being listened. Don't know what
to try next.

Sometimes when I shut down my laptop the "stop" messages are displayed.
I noticed last night that pg_ctl could not find the postmaster.pid file,
even though PGHOST and PGDATA variables are set. I'm starting it with
the -i and -D options with -D pointing explicitly to the PGDATA path
using the full path name. Could not finding a postmaster.pid file be
linked in any way with my problem??


Cheers,
Rob

rob@roblaptop:~> netstat -ln --tcp
Active Internet connections (only servers)
Proto Recv-Q Send-Q Local Address           Foreign Address
State
tcp        0      0 0.0.0.0:22              0.0.0.0:*
LISTEN
tcp        0      0 127.0.0.1:631           0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:5432            0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:58112           0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:2049            0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:44739           0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:6566            0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:60135           0.0.0.0:*
LISTEN
tcp        0      0 0.0.0.0:111             0.0.0.0:*
LISTEN
tcp6       0      0 :::22                   :::*
LISTEN
tcp6       0      0 ::1:631                 :::*
LISTEN
tcp6       0      0 :::5432                 :::*
LISTEN
tcp6       0      0 :::6566                 :::*
LISTEN
tcp6       0      0 :::80                   :::*
LISTEN
rob@roblaptop:~>




On Wed, 2010-12-08 at 08:52 +1300, Oliver Jowett wrote:
> On 08/12/10 02:29, Rob Stone wrote:
>
> > Wrote a mickey mouse java class (testdbconn) to see if I could access
> > the database and read data from a table that has two rows. See attached.
> > When it runs it displays the same SQL error code as ExecuteQuery --
> > 08001 -- which is the "can't connect error".
>
> You have a network configuration problem of some sort:
>
> > Caused by: java.net.SocketException: Network is unreachable
>
> (This isn't "connection refused", it's "I have no configured route to
> that address")
>
> Oliver



pgsql-jdbc by date:

Previous
From: "Mackay, Scott"
Date:
Subject: Status of setQueryTimeout
Next
From: Dave Cramer
Date:
Subject: Re: Connection Problem