From: | Dave Cramer <pg(at)fastcrypt(dot)com> |
---|---|
To: | Rob Stone <robstone(at)mira(dot)net> |
Cc: | Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org |
Subject: | Re: Connection Problem |
Date: | 2010-12-09 20:18:06 |
Message-ID: | AANLkTi=k+di1DrCktfvGEVV4HeHZFgs1WFdf3u+Jh1n9@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)mira(dot)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(at)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(at)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(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-jdbc
>
From | Date | Subject | |
---|---|---|---|
Next Message | Radosław Smogura | 2010-12-09 20:43:47 | Re: Connection Problem |
Previous Message | Rob Stone | 2010-12-09 13:18:11 | Re: Connection Problem |