Re: postgres connection issues

Thank you.
I will try to get it installed.
Cheers,
Markus

On Thu, Apr 21, 2016 at 2:17 PM, Kevin Struckhoff <kevins(at)thermal(dot)com>
wrote:

> HI Markus,
>
>
>
> Sounds like the issue is w/ squirrel then. Have you tried using pgAdmin?
> It can be downloaded from http://pgadmin.org
>
>
>
> Good Luck
>
>
>
> Kevin
>
>
>
>
>
> *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 2:08 PM
> *To:* Day, David <dday(at)redcom(dot)com>; 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> 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
>
>
>