Skip to content

Instantly share code, notes, and snippets.

@vivekrk1992

vivekrk1992/pg_hba.conf

Created February 20, 2021 06:45
Show Gist options
  • Save vivekrk1992/0c4426a7e0a9bbb4f7109a0789a70e96 to your computer and use it in GitHub Desktop.
Save vivekrk1992/0c4426a7e0a9bbb4f7109a0789a70e96 to your computer and use it in GitHub Desktop.
Download ZIP
Server database allow all connection
Raw
pg_hba.conf
file location
/etc/postgresql/12/main
# add this line to end of the file
host all all 0.0.0.0/0 md5
Raw
postgresql.conf
file location
/etc/postgresql/12/main
#listen_addresses = 'localhost' # what IP address(es) to listen on;
listen_addresses = '*'
Raw
what we do
restart postgresql server
sudo service postgresql restart
if you use ufw please check that port also
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment