Tuesday, August 18, 2015

PostgreSQL Allow Connections from Everywhere

PostgreSQL doesn't normally allow connections from everywhere.
But for development you might want to enable it.

On Windows, a typical path to the file to edit is like:
C:\Program Files\PostgreSQL\9.4\data\pg_hba.conf

Add a line like this to the end of that file:
host    all             all             0.0.0.0/0            md5

Also make sure your firewall allows remote machines to get in, or it won't matter if _only_ postgres allows them.

No comments:

Post a Comment