Skip to content

Instantly share code, notes, and snippets.

@yalin

yalin/postgres remote access

Last active February 16, 2022 05:14
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save yalin/ec78fb73899762e12f732fd9a98be79c to your computer and use it in GitHub Desktop.
Save yalin/ec78fb73899762e12f732fd9a98be79c to your computer and use it in GitHub Desktop.
Download ZIP
Raw
postgres remote access
edit;
* postgresql.conf
* pg_hba.conf
cd /etc/postgresql/12/main (Linux)
### postgresql.conf
set listen_addresses = '*'
### pg_hba.conf
# IPv4 local connections:
host all all 0.0.0.0/0 md5
sudo service postgresql stop
sudo service postgresql start
sudo ufw allow 5432
resource: https://o7planning.org/12255/configure-postgresql-to-allow-remote-connections
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment