On Sat, Mar 31, 2018 at 11:44 AM, Mike Martin <redtux1@gmail.com> wrote:
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
>So a bit confused, is psql ignoring the host parameter
It is not ignoring your entry, you simply have not entry for the laptop you are connecting from, So simply add the following:
host all all 192.168.0.2/32 ident <- note, you may have to change the authentication method depending on your environment