Re: postgres connection issues

Hi

Probably this:

Add to your pg_hba.conf

# IPv4 local connections:
host all all 127.0.0.1/32 trust
host all all <ip of your windows machine>/32 trust

From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of Markus Metz
Sent: Thursday, April 21, 2016 3:25 PM
To: pgsql-novice(at)postgresql(dot)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<http://127.0.0.1/32> trust
host all all 0.0.0.0/0<http://0.0.0.0/0> trust
c) The server is running and listening at the correct port on the linux site:
ps -efl | grep postgres
netstat -nlp | grep postgres

What else could I try to enable a communication?

Any suggestion is highly appreciated.

Best,

Markus