host all all <ip of your windows machine>/32 trust
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Markus Metz Sent: Thursday, April 21, 2016 3:25 PM To: pgsql-novice@postgresql.org Subject: [NOVICE] postgres connection issues
Dear all:
I searched the web and all what I tried did not work. So please bear with me:
I trying to access a database on a linux machine from a windows computer using SQuirrel:
postgres version 9.4.5
Squirrell version 3.7
However, I am getting the error message on SQuirrel:
Connection to host:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
This is what I have done:
a) Changed postgresql.conf: listen_addresses = '*'
b) edited pg_hba.conf: host all all 127.0.0.1/32 trust