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.5Squirrell version 3.7However, 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 connectionsThis is what I have done:a) Changed postgresql.conf: listen_addresses = '*'b) edited pg_hba.conf: host all all 127.0.0.1/32 trusthost 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 postgresnetstat -nlp | grep postgresWhat else could I try to enable a communication?Any suggestion is highly appreciated.Best,Markus
В списке pgsql-novice по дате отправления: