postgresql_user module: fe_sendauth: no password supplied

[Michael Shi]

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

[Michael Shi]

Any ideas anyone?

[Brian Coca]

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.

--
Brian Coca