No Pg Hba.conf Entry For Host

The problem is that the name 'localhost' by default resolves to multiple different loopback addresses on OS X:. 127.0.0.1 (IPv4 loopback).::1 (IPv6 loopback). fe80::1%lo0 (IPv6 loopback on a specific interface)The PostgreSQL client tries connecting to each address in turn. The order of the addresses is determined by the getaddrinfo system call, and more or less random.Once the client is connected, the server checks which address the client is connecting from (in the case of loopback that's the same as the effective server address).

So if your client ends up connecting to fe80::1%lo0, the server wont find a corresponding entry in pghba.conf.I can think of a few workarounds. Each of them should fix the issue:. Set your server to listen only on 127.0.0.1 to avoid connections via IPv6 in postgresql.conf. Edit /etc/hosts to remove the fe80::1%lo0 address (might have unknown sideeffects, this is probably there for a reason, even if I don't know why). Change your connection settings to connect to host 127.0.0.1 or::1 instead of localhost. Add a line for fe80::1%lo0 to pghba.confYou can find the config files in the data directory (see prefs, or ).

In your pghba.conf file, I see some incorrect and confusing lines: # fine, this allows all dbs, all users, to be trusted from 192.168.0.1/32 # not.

Logmein dpms drivers for mac. Right click, hit uninstall. This might moniitor an old thread – but I need assistance on this.