Re: postgres connection issues
От | Day, David |
---|---|
Тема | Re: postgres connection issues |
Дата | |
Msg-id | 401084E5E73F4241A44F3C9E6FD794280378FC4D62@exch-01 обсуждение исходный текст |
Ответ на | postgres connection issues (Markus Metz <metma99@gmail.com>) |
Ответы |
Re: postgres connection issues
|
Список | pgsql-novice |
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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Markus Metz
Sent: Thursday, April 21, 2016 3:25 PM
To: pgsql-novice@postgresql.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
В списке pgsql-novice по дате отправления: