PostgreSQL: " no pg_hba.conf entry for host"
error: no pg_hba.conf entry for host "172.22.156.77", user "postgres", database "postgres", SSL off
先找出pg_hba.conf檔案,我的是Win10下安裝的,位置如下
C:\Program Files\PostgreSQL\13\data\pg_hba.conf
然後在檔案最後加入如下
# host all all (客戶端的ip)/32 (為方便troubleshoot所以我設為trust)
host all all 172.22.156.77/32 trust
簡單吧? Resolved?