Allow db access with password authentication in LAN

in file “pg_hba.conf”:

# TYPE  DATABASE    USER        CIDR-ADDRESS          METHOD

# "local" is for Unix domain socket connections only
local   all         all                               trust
# IPv4 local connections:
host    all         all         127.0.0.1/32          trust
host    paintdb     jcolors     192.168.98.0/24       password
host    all         all         192.168.98.0/24       password
# IPv6 local connections:
host    all         all         ::1/128               trust

Advertisement