Create Server in pgAdmin 4 with external IP

Asked

Viewed 1,510 times

0

I am trying to create a server with external IP in my pgAdmin 4, but the following error occurs when I try to save it:

inserir a descrição da imagem aqui

Accessing the file pg_hba.conf I found that the same is so currently:

TYPE DATABASE USER ADDRESS METHOD

Ipv4 local Connections:
host all 192.168.1.130/32 md5
host all 0.0.0/0 trust

Ipv6 local Connections:
host all ::1/128 md5

I tried to change the line host all 192.168.1.130/32 md5 for host postgres postgres 192.168.1.130/32 md5, but the error persists;

If you have any suggestions.

1 answer

0


I found that the error was not actually in my machine but in the Server where the Postgresql was installed, there file settings pg_hba.conf wrong configuration of hosts that allowed access to the bank.

Solution found:

Change line:

host all 192.168.1.130/32 trust

To:

host postgres postgres 192.168.1.130/32 md5

Browser other questions tagged

You are not signed in. Login or sign up in order to post.