Hi Adrian,
> First match wins loses in this case. The entries are processed top to
> bottom the first the one matches in this case:
>
> local all all peer
>
> Per
This answers my question. Thanks for the help,
--
Chris.
Hi David,
> The second line is pointless, the first three columns are compared against the
> incoming connection host/user/dbname to find out how authentication should be
> handled. The first match wins. So for every local connection peer, and only
> peer, is going to be used since everything mat
Hi Folks,
I am confused about authentication. I understand that in the local connection
case, I have choices of “peer”, and “md5” (password).
In pg_hba.conf, I have the lines:
local all all peer
local all all md5
I have an OS user “postgres”, and I can “su – postgres”, which brings me to