Re: postgres connection issues - Mailing list pgsql-novice

From Day, David
Subject Re: postgres connection issues
Date
Msg-id 401084E5E73F4241A44F3C9E6FD794280378FC4D62@exch-01
Whole thread Raw
In response to postgres connection issues  (Markus Metz <metma99@gmail.com>)
Responses Re: postgres connection issues
List 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 by date:

Previous
From: Steve Crawford
Date:
Subject: Re: postgres connection issues
Next
From: Markus Metz
Date:
Subject: Re: postgres connection issues