Re: 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> wrote:

> 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 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
>