hari-p
1/29/2018 - 2:37 AM

How to allow remote connections to your local development PostgreSQL server?

How to allow remote connections to your local development PostgreSQL server?

How to allow remote connections to your local development PostgreSQL server?
Find the pg_hba.conf file for your local development PostgreSQL server instance.
If you know the PostgreSQL base directory then typically this conf file will be in (base)/PostgreSQL/9,0/data/pg_hba.conf

If you don't know the base directory, then use Windows File Search, or with Cygwin try find . -type f | grep pg_hba.conf

Add the following line at the bottom of your pg_hba.conf file

host all all xxx.xxx.xxx.x/24 trust