| From: | Mike Martin <redtux1(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Problem with connection to host (wrong host) |
| Date: | 2018-03-31 15:44:29 |
| Message-ID: | CAOwYNKZ7LB0SV-U7avdJ2T6rRpTv5KZJ4VSJccgcF+r4VxWg8A@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi
I am just setting up a postgres server, details
Host 192.168.0.3
pg_hba.conf
# TYPE DATABASE USER ADDRESS METHOD
# "local" is for Unix domain socket connections only
local all all peer
# IPv4 local connections:
host all all 192.168.0.0/32 ident
# IPv6 local connections:
host all all 127.0.0.1/32 ident
host all all ::1/128 ident
postgresql.conf
listen_addresses-'*'
however when I try to connect from my laptop (ip 192.168.0.2) I get
psql -h 192.168.0.3 -U usevideo -W
Password for user usevideo:
psql: FATAL: no pg_hba.conf entry for host "192.168.0.2", user "usevideo",
database "usevideo", SSL off
So a bit confused, is psql ignoring the host parameter
thanks
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Eisentraut | 2018-03-31 15:59:12 | Re: Problem with connection to host (wrong host) |
| Previous Message | Vijaykumar Jain | 2018-03-31 09:53:54 | Re: Redacting params in PostgreSQL logs |