ansible-postgresql
ansible-postgresql copied to clipboard
Allow authentication of non-system database users
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
ping @natefoo
Thanks for the submission @pieterlexis. Can you verify that this does not affect system users using peer authentication?