Re: Connection Problem - Mailing list pgsql-jdbc
From | Dave Cramer |
---|---|
Subject | Re: Connection Problem |
Date | |
Msg-id | AANLkTi=k+di1DrCktfvGEVV4HeHZFgs1WFdf3u+Jh1n9@mail.gmail.com Whole thread Raw |
In response to | Re: Connection Problem (Rob Stone <robstone@mira.net>) |
Responses |
Re: Connection Problem
|
List | pgsql-jdbc |
Rob, Have you tried 127.0.0.1 instead of localhost ? It's not that it isn't listening, the problem is there is no route to localhost which seems strange on it's own. Dave On Thu, Dec 9, 2010 at 8:18 AM, Rob Stone <robstone@mira.net> wrote: > 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 > > > > -- > Sent via pgsql-jdbc mailing list (pgsql-jdbc@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-jdbc >
pgsql-jdbc by date: