0
I am using NO-IP to connect to an internal server in my office. I’ve already released port 5432 on the machine’s firewall and I’ve also set up the pg_hba.conf and postgresql.conf files (I’ll leave the 2 here). Already tested the door by the site insert link description here and everything happens perfectly. But when I try to access the bank by pgadmin from 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 the machine control panel (server) indicates a new connection to my external IP , but after a few moments it disconnects and shows the error on the other machine (in which I am trying to use pgadmin to connect to the server) .
pg_hba.conf
host all 0.0.0/0 trust
postgresql.conf
listen_addresses = '*' # what IP address(s) to Listen on;
You didn’t specify how the network is. If your network has NAT, you may need port forwarding from your router/switch to the database server’s network IP.
– Rafael Araújo
I have already made port redirection on all routers here ... And in the tests I do I can communicate with port TCP 5432 , only in the post that gives this error ...
– Felipe Laera
Authentication will not cause problems when connecting to the database, IP will. Try to put it in the pg_hba.conf line
host all all all md5– Laércio Lopes
It keeps giving the same error . I tried to use the pgadmin in a friend’s house by accessing the bank here and it worked ... So it doesn’t work when I try to access from here using the external ip. When I try to access from the internal network it works .
– Felipe Laera