Re: Cannot reach pg server using -h localhost

On 07/21/2015 12:57 PM, Fritz Meissner wrote:
>>
>> So what happens if you?:
>>
>> ping 127.0.0.1
>
> ping 127.0.0.1
> PING 127.0.0.1 (127.0.0.1): 56 data bytes
> 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.044 ms
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.162 ms
> ...
>
>> ping localhost
>
> ping localhost
> PING localhost (127.0.0.1): 56 data bytes
> 64 bytes from 127.0.0.1: icmp_seq=0 ttl=64 time=0.038 ms
> 64 bytes from 127.0.0.1: icmp_seq=1 ttl=64 time=0.128 ms
> ...
>
>

Just realized that my suggestion above was redundant, because of this:

"
psql -Umyuser -d mydb -h localhost
psql: server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.

Server log:

[unknown] LOG: connection received: host=::1 port=51186
(... and that's it, no connection authorized line)

> So what happens if you do?:
>
> psql -U myuser -d mydb -h 127.0.0.1
>

Same thing. Pause for about 30 seconds and then "server closed the
connection unexpectedly". Server log just shows:

[unknown] LOG: connection received: host=127.0.0.1 port=51919

So psql -h <whatever> is reaching the server, it is failing at that
point though.

"

<Scratches head>

1) Can you access the Postgres server from another machine?

2) I know in your original post you did a which on psql, but is there
more then one instance/install of Postgres on this machine?

The reason I ask is this from the original post:

psql -Umyuser -d mydb
sql (9.3.5)
Type "help" for help.

myuser=#

That indicates a 9.3.5 version of psql. Not sure if that is the current
state or a cut and paste from when you said you where running 9.3.5,
before installing 9.4?
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com