From: | "Kevin Struckhoff" <kevins(at)thermal(dot)com> |
---|---|
To: | Markus Metz <metma99(at)gmail(dot)com> |
Cc: | "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org> |
Subject: | Re: postgres connection issues |
Date: | 2016-04-21 21:17:30 |
Message-ID: | CO2PR01MB2023B72CB7228D0CAFD16463D26E0@CO2PR01MB2023.prod.exchangelabs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
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<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
From | Date | Subject | |
---|---|---|---|
Next Message | Markus Metz | 2016-04-21 21:21:33 | Re: postgres connection issues |
Previous Message | Bao Ton | 2016-04-21 21:13:18 | Re: Functions as conditions |