Ritu Khetan <RKhetan@xxxxxxxxxx> writes: > # IPv4 local connections: > host all all 127.0.0.1/32 trust > # IPv6 local connections: > #host all all ::1/128 trust > #host all all 172.21.42.121/24 trust > host all all 172.21.51.56/24 trust > While this works at most of the locations, we have a peculiar error coming > up at 2-3 locations. The error reads: > no pg_hba.conf entry for host "::1" , user "crisil" , database "crisil" , > SSL off " No surprise: you have the IPv6 line commented out. Dunno why these particular boxes are preferring IPv6 to IPv4, maybe something different about the local DNS environment? Anyway, there is no point in refusing to serve ::1/128 if you're accepting 127.0.0.1. regards, tom lane
