Re: postgres connection issues

Hi,

Did you restart or force reload of configuration files by postgress after any of your changes to pg_hba.conf or postgresql.conf file.
Your pg_hba entry of 0.0.0.0/0 trust should have allowed any client attachment. So my initial suggestion was
un-necessary.

Dave

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 5:08 PM
To: Day, David; scrawford(at)pinpointresearch(dot)com
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] postgres connection issues

Hi David and Steve:
Thank you for your suggestions.

I changed pg_hba.conf but no success. Same error.

I was able to connect via putty to the server via port 5432 according to
http://www.postgresonline.com/journal/archives/38-PuTTY-for-SSH-Tunneling-to-PostgreSQL-Server.html

Cheers,
Markus

On Thu, Apr 21, 2016 at 1:19 PM, Day, David <dday(at)redcom(dot)com<mailto:dday(at)redcom(dot)com>> wrote:
Hi

Probably this:

Add to your pg_hba.conf

# IPv4 local connections:
host all all 127.0.0.1/32<http://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> [mailto: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<mailto: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