venkatd/pghero-setup.md

Last active February 10, 2021 19:44

Star (1) You must be signed in to star a gist
Fork (0) You must be signed in to fork a gist

Learn more about clone URLs
Clone this repository at <script src="https://gist.github.com/venkatd/236470bcb4bc4eab435ec72f20de5c5a.js"></script>
Save venkatd/236470bcb4bc4eab435ec72f20de5c5a to your computer and use it in GitHub Desktop.

Download ZIP

Raw

pghero-setup.md

Setting up pghero

Install docker for Mac

https://www.docker.com/docker-mac

Install pghero

Run the following commands

localip=$(ifconfig | grep "inet " | grep -v 127.0.0.1 | cut -d\  -f2)
dburl=postgres://[email protected]:5432/turtle_dev
docker rm hero
docker run -ti -e DATABASE_URL=$dburl --add-host=docker.local:$localip -p 8080:8080 --name hero ankane/pghero

Allow access to local postgres installation

Edit the configuration file in postgres to allow all ips

listen_addresses = '*' in the postgresql.conf file. Make sure to uncomment it.
Make sure you have the following entry in pg_hba.conf:

# TYPE  DATABASE        USER            ADDRESS                 METHOD
host  all  all 0.0.0.0/0 trust

Restart server

View in the browser

open http://localhost:8080

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment