Skip site navigation (1) Skip section navigation (2)

Re: Connection Problem

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: Dave Cramer <pg(at)fastcrypt(dot)com>
Cc: Rob Stone <robstone(at)mira(dot)net>, Oliver Jowett <oliver(at)opencloud(dot)com>, pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Connection Problem
Date: 2010-12-09 20:43:47
Message-ID: 20101209154347.19402ab3a4rxuttv@softperience.eu (view raw or flat)
Thread:
Lists: pgsql-jdbc
Hi,

Check with netstat -atnp (it shows the process associated with port),  
but psql should be there.

Do route -n to see routing traces, execute ifconfig next.

But this can be kernel driver problem. Do you "shut down" laptop by  
closing it, I mean do you put it in sleep mode? Maybe you need to  
restart network interfaces instead.

On my PC when I put it on sleep mode, SATA controller doesn't wakes up.

Kind regards,
Radek Smogura
> 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
>>
>
> --
> 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
>



In response to

Responses

pgsql-jdbc by date

Next:From: Rob StoneDate: 2010-12-09 23:48:30
Subject: Re: Connection Problem
Previous:From: Dave CramerDate: 2010-12-09 20:18:06
Subject: Re: Connection Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group