bash-4.1$ psql
psql (8.4.20)
Type "help" for help.
postgres=# SHOW hba_file;
hba_file
---------------------------------
/var/lib/pgsql/data/pg_hba.conf
(1 row)
- reference: http://askubuntu.com/questions/256534/how-do-i-find-the-path-to-pg-hba-conf-from-the-shell
- Edit file:
vim /var/lib/pgsql/data/pg_hba.conf
- File path from
SHOW hba_file;
above
- File path from
- Add these two (active) lines)
# Heroku - metrics app - static IP 1
host all all 52.86.18.14 255.255.255.255 password
# Heroku - metrics app - static IP 2
host all all 50.17.160.202 255.255.255.255 password
SELECT pg_reload_conf();
[qgtunnel.postgres]
accept = "localhost:5432"
#connect = "demo.dataverse.org:5432"
connect = "dvndb-qa1.hmdc.harvard.edu:5432"
- Update:
DV_DEMO_DATABASE_URL