Minimal permissions on PostreSQL for Veeam Agent to perform backup?

[mark1117]

Hi，
I would like to avoid using the ‘root’ account for backup postresql,so I want to know minimal permissions on PostreSQL for Veeam Agent to perform backup.In my environment,use veeam agent 5.0.2 on centos8,postresql 14.0
I hope someone can help me.

[Mildur]

Hi Mark

We are doing a write-ahead log checkpoint.
The official postgresql documention mentions that superuser permissions are required until v14. V15 seems to have a new permission role for this checkpoints.

https://www.postgresql.org/docs/14/sql-checkpoint.html

Only superusers can call CHECKPOINT.

https://www.postgresql.org/docs/current ... point.html

Only superusers or users with the privileges of the pg_checkpoint role can call CHECKPOINT.

Best,
Fabian

[mark1117]

This is very helpful for me,thanks for your reply.

[Mildur]

You're welcome.
Note: PostgreSQL v15 is not supported yet by Veeam agent for linux.
Maybe it works, but we haven't tested it yet.

Thanks
Fabian