Create Server in pgAdmin 4 with external IP

Navigation
0

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

Accessing the file pg_hba.conf I checked that it is currently so:

TYPE DATABASE USER ADDRESS METHOD

IPv4 local connections:
host all all 192.168.1.130/32 md5
host all all 0.0.0.0/0 trust

IPv6 local connections:
host all all :: 1/128 md5

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

If you have any suggestions.

    
asked by anonymous 01.12.2016 / 12:02

1 answer

0

I discovered that the error was not actually on my machine but on the server where PostgreSQL was installed, there the settings of the pg_hba.conf file were wrong configuration of hosts that would allow access to the database .

Solution found:

Change the line:

host all 192.168.1.130/32 trust

To:

host postgres postgres 192.168.1.130/32 md5

    
01.12.2016 / 14:20
I have a very extensive query when I try to insert in the database it does not work, I do not know why Arduino and PHP communication via serial