Личный кабинет
Укажите e-mail, на который будет выслан код восстановления пароля.
На указанный вами адрес e-mail был выслан код подтверждения аккаунта. Введите полученный код для продолжения:
Введите новый пароль два раза:
Hi, Did you restart or force reload of configuration files by postgress after any of your changes to pg_hba.conf or postgresql.conf file.Your pg_hba entry of 0.0.0.0/0 trust should have allowed any client attachment. So my initial suggestion wasun-necessary. Dave From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Markus MetzSent: Thursday, April 21, 2016 5:08 PMTo: Day, David; scrawford@pinpointresearch.comCc: pgsql-novice@postgresql.orgSubject: 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@redcom.com> wrote:Hi Probably this: Add to your pg_hba.conf # IPv4 local connections:host all all 127.0.0.1/32 trusthost 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 MetzSent: Thursday, April 21, 2016 3:25 PMTo: pgsql-novice@postgresql.orgSubject: [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.5Squirrell 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 trustc) 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
Hi,
Did you restart or force reload of configuration files by postgress after any of your changes to pg_hba.conf or postgresql.conf file.
Your pg_hba entry of 0.0.0.0/0 trust should have allowed any client attachment. So my initial suggestion was
un-necessary.
Dave
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Markus MetzSent: Thursday, April 21, 2016 5:08 PMTo: Day, David; scrawford@pinpointresearch.comCc: pgsql-novice@postgresql.orgSubject: 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@redcom.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@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of Markus MetzSent: Thursday, April 21, 2016 3:25 PMTo: pgsql-novice@postgresql.orgSubject: [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,
В списке pgsql-novice по дате отправления: