linux - Modify pg_hba.conf file to allow me access -
i keep getting error when trying connect psql database, "connection closed remote host". have tried modifying pg_hba.conf file allow ip of computer have access, still same error, doing wrong? have restart server or something?
host all <ip>/32 md5
as well, have seen /24 instead of /32, how know number use?
the notation "/32" refers single ip address whereas notation "192.168.1.0/24" refers addresses on 192.168.1.x network.
and yes, have sql restart, like:
service postmaster restart
but make sure ip address restrictive hackers won't visiting database day. use "localhost" if can (127.0.0.1).
Comments
Post a Comment