Re: postgres connection issues - Mailing list pgsql-novice

From Steve Crawford
Subject Re: postgres connection issues
Date
Msg-id CAEfWYywBu+S+FQ0Qd8htUQ88wabqDTAiWbyo+cAaoupeEZPmpw@mail.gmail.com
Whole thread Raw
In response to postgres connection issues  (Markus Metz <metma99@gmail.com>)
List pgsql-novice
Is there a firewall in place on the server side (perhaps that you didn't set up)? Some distributions are fairly "locked down" out of the box and you have to specifically open ports you want to use.

Cheers,
Steve


On Thu, Apr 21, 2016 at 12:25 PM, Markus Metz <metma99@gmail.com> wrote:
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
    host all all 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

pgsql-novice by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Functions as conditions
Next
From: "Day, David"
Date:
Subject: Re: postgres connection issues