Re: postgres connection issues

Поиск
Список
Период
Сортировка
От Steve Crawford
Тема Re: postgres connection issues
Дата
Msg-id CAEfWYywBu+S+FQ0Qd8htUQ88wabqDTAiWbyo+cAaoupeEZPmpw@mail.gmail.com
обсуждение исходный текст
Ответ на postgres connection issues  (Markus Metz <metma99@gmail.com>)
Список pgsql-novice
Is there a firewall in place on the server side (perhaps that you didn't set up)? Some distributions are fairly "locked down" out of the box and you have to specifically open ports you want to use.

Cheers,
Steve


On Thu, Apr 21, 2016 at 12:25 PM, Markus Metz <metma99@gmail.com> wrote:
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 по дате отправления:

Предыдущее
От: "David G. Johnston"
Дата:
Сообщение: Re: Functions as conditions
Следующее
От: "Day, David"
Дата:
Сообщение: Re: postgres connection issues