postgresql_user module: fe_sendauth: no password supplied

Archives Ansible Project
1

I’m trying to use the postgresql_user module, but I keep getting unable to connect to database: fe_sendauth: no password supplied

Doing the same on postgresql_db module seems to work
Is it a problem authenticating as the postgres user?

users.yml

  • name: PostgreSQL | Make sure the PostgreSQL users are present
    postgresql_user:
    name: “{{item.name}}”
    password: “{{item.password | default(‘pass’)}}”
    state: present
    login_host: “{{item.host | default(‘localhost’)}}”
    with_items: postgresql_users
    when: postgresql_users|length > 0

main.yml

  • include: users.yml
    tags: [postgresql, postgresql-users]
    sudo: yes
    sudo_user: postgres
2

Any ideas anyone?

3

sudo_user: postgres should not require a password on normal setups as
it should use the local socket directly. Try setting it on the task
in users.yml instead of on the include.