I am trying to connect to my database on a remote server using QGIS. From what I've read I have to edit the
pg_hba.conf and the
postgresql.conf files. I think I have edited these files to allow any IP to connect using the password (not very secure but I'll sort that out when I get this issue figured out). I have verified that my parameters in the PostGIS connection tool are correct.
When I try to connect to the database it says theres an error. I'm not sure if I missed a step or if I did anything incorrect, can anyone give me some suggestions on how to get this accomplished?
# IPv4 local connections: host all all 0.0.0.0/0 md5 # IPv6 local connections: host all all ::0/0 md5 # Allow replication connections from localhost, by a user with the # replication privilege. host replication all 0.0.0.0/0 md5 host replication all ::0/0 md5
Versions: QGIS 3.4.14, PostgreSQL 10, pgAdmin 4
OS: Client side -> Windows 10, Server side -> Windows Server 2012