ansible-postgresql icon indicating copy to clipboard operation
ansible-postgresql copied to clipboard

Allow authentication of non-system database users

Open pieterlexis opened this issue 10 years ago • 2 comments

Hi,

I was using you role and discovered that I always got the 'peer authentication failed' message when connecting to the database as a non-system user created with ansible's postgresql_user. The attached patch moves the postgresql_pg_hba entries up so they are matched before the peer authentication of system users.

Let me know if something about the reasoning above is incorrect and I'll see to it.

Best regards,

Pieter Lexis

pieterlexis avatar Nov 13 '15 11:11 pieterlexis

ping @natefoo

bgruening avatar Jul 03 '16 14:07 bgruening

Thanks for the submission @pieterlexis. Can you verify that this does not affect system users using peer authentication?

natefoo avatar Jul 05 '16 17:07 natefoo