Postgre error trying to access externally

0

I'm using NO-IP to connect to an internal server in my office. I have already freed port 5432 on the machine firewall and also configured the pg_hba.conf and postgresql.conf files (I will leave the 2 here). I tried the door on insert the link description here and everything happens perfectly. But when I try to access the database through the pgadmin of another machine using my external IP as host it returns me the following error:

  

server closed the connection unexpectedly this probably means the server terminated abnormally before or while processing the request.

It even seems to connect, because in the control panel of the machine (server) indicates a new connection with my external IP, but after a few moments it disconnects and shows the error in the other machine (in which I am trying to use pgadmin to connect to the server).

pg_hba.conf

host all all 0.0.0.0/0 trust

postgresql.conf

listen_addresses = '*' # what IP address (es) to listen on;

    
asked by anonymous 01.02.2017 / 07:06

0 answers