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.klaver@aklaver.com
