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://venkat@docker.local: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

1. listen_addresses = '*' in the postgresql.conf file. Make sure to uncomment it.
2. 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

3. Restart server

View in the browser

open http://localhost:8080