From: | Markus Metz <metma99(at)gmail(dot)com> |
---|---|
To: | "Day, David" <dday(at)redcom(dot)com>, pgsql-novice(at)postgresql(dot)org |
Subject: | Re: postgres connection issues |
Date: | 2016-04-22 13:40:12 |
Message-ID: | CAGQZDOFQAAL5wao=bB3JKW6L8z4vzz-jfvB5_9UHVaGc_idGqA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-novice |
Hello Dave:
I am using supervisord to run postgress.
So for each change in pg_hba.conf or postgresq.conf I stopped the
supervisor service and started it again.
Markus
On Fri, Apr 22, 2016 at 5:06 AM, Day, David <dday(at)redcom(dot)com> wrote:
> 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(at)postgresql(dot)org [mailto:
> pgsql-novice-owner(at)postgresql(dot)org] *On Behalf Of *Markus Metz
> *Sent:* Thursday, April 21, 2016 5:08 PM
> *To:* Day, David; 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
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Kip Warner | 2016-04-22 18:44:55 | Tricky math in PSQL |
Previous Message | Day, David | 2016-04-22 12:06:19 | Re: postgres connection issues |