i am trying to setup pgbackrest with ansible and i have stumbled upon GRANTing EXECUTE on the function pg_backup_start i have the following ansible snippet: - name: GRANT EXECUTE on function pg_start_backup community.postgresql.postgresql_privs: database: postgres privs: EXECUTE …

How to grant execute on pg_backup_start

Cepxio (Sergio Ostapowicz) May 31, 2024, 2:10pm 2

Hi Freddik,

I hope you are well,

It seems that the Postgres function name is not correct.

1 Like

Topic		Replies	Views
postgresql_user and granting select on pg_stat_database Ansible Project	3	16	March 19, 2015
How to execute SQL query on PostgreSQL? Ansible Project	4	21	December 2, 2021
postgresql_privs equivalent for GRANT statement + solution Ansible Project	0	33	August 4, 2023
mysql_user EXECUTE ON PROCEDURE Ansible Project	1	14	August 4, 2016
Postgres - grant role to user Ansible Project	1	13	June 29, 2015