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@xxxxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
