-
|
Trying to connect to the remote database, which ive installed onto 192.168.1.95, created firewall rules & service is running. My host 192.168.1.226 ive installed the cli tools and added to my path variable, and when I attempt to connect, I get this error in the title. Am I supposed to have a pg_hba.conf file on my host machine? It exists on the server.
|
Beta Was this translation helpful? Give feedback.
Replies: 1 comment
-
|
Fixed it. This is my first experience with postgresSQL and now I understand that I need to add my host machine address into the pg_hba.conf file on the server. I added this line: host all all 192.168.1.226 scram-sha-256 |
Beta Was this translation helpful? Give feedback.
Fixed it. This is my first experience with postgresSQL and now I understand that I need to add my host machine address into the pg_hba.conf file on the server. I added this line:
host all all 192.168.1.226 scram-sha-256