On Dec 31, 2024, at 13:31, Nick <lists2@xxxxxxxxxxxxxx> 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