On Dec 31, 2024, at 13:31, Nick <lists2(at)ageofdream(dot)com> wrote:
> What is the proper (secure) way to let the Ansible POSIX user manage
> postgres? It seems there should be a fully automated way to bootstrap
> an Ansible user for `postgres`.
This is generally done with "become" and "become_user" in a shell command, something like:
- name: Do something as the postgres user
ansible.builtin.shell: "psql ..."
register: pgbackrest_which_output
become: true
become_user: postgres