Hi Christoph,

Would you agree with me, i.e. do you know the following to be true, that
peer authentication requires Unix socket (localhost) and that Unix
socket requires peer identification for PostgreSQL?

I tried the other day to have password authentication via the Unix
socket, but that failed:
root@sid:/# psql -U icinga234 -W
Password for user icinga234:
psql: FATAL:  Peer authentication failed for user "icinga234"

If this is true, I think it warrants some improved logic during config.

By the way, I see that PostgreSQL has a lot more authentication
possibilities than when Sean invented dbconfig. I don't think I am going
to support this on the short/mid term, but it may warrant improved
messages here and there.

Paul
PS: I believe this works different for MySQL/MariaDB, so the answer is
not trivial.

Attachment: signature.asc
Description: OpenPGP digital signature

Reply via email to