Allow authentication of non-system database users

galaxyproject / ansible-postgresql

An Ansible role for managing a PostgreSQL server

https://galaxy.ansible.com/galaxyproject/postgresql

122 stars 58 forks source link

Allow authentication of non-system database users #5

Open pieterlexis opened 8 years ago

pieterlexis commented 8 years ago

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

bgruening commented 8 years ago

ping @natefoo

natefoo commented 8 years ago

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