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

Popular posts from this blog

android - MPAndroidChart - How to add Annotations or images to the chart -

javascript - Add class to another page attribute using URL id - Jquery -

firefox - Where is 'webgl.osmesalib' parameter? -