How to set postgres password using ansible

Question

Usually I do :

sudo -su postgres
psql
\password
\q

to change postgres password. Now I want to automate this step using ansible.

Raj Verma · Accepted Answer · 2021-08-31 20:10:50Z

6

Ansible postgresql_user module will help to set/reset the database user password. Here is the sample

- name: pd reset database user
  become: yes
  become_method: sudo
  become_user: postgres
  postgresql_user: 
    db: test
    name: test
    password: ""

For Reference, here is ansible link: https://docs.ansible.com/ansible/latest/collections/community/postgresql/postgresql_user_module.html#ansible-collections-community-postgresql-postgresql-user-module

edited Aug 31, 2021 at 20:10

Raj Verma

1,1821 gold badge10 silver badges22 bronze badges

answered Aug 7, 2020 at 14:18

user94153

761 bronze badge

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to set postgres password using ansible

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related