Agent-based backup of Windows, Linux, Max, AIX and Solaris machines.
Post Reply
mark1117
Novice
Posts: 5
Liked: 1 time
Joined: Nov 16, 2022 7:46 am
Contact:

Minimal permissions on PostreSQL for Veeam Agent to perform backup?

Post by 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
Product Manager
Posts: 8341
Liked: 2171 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Minimal permissions on PostreSQL for Veeam Agent to perform backup?

Post by 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
Product Management Analyst @ Veeam Software
mark1117
Novice
Posts: 5
Liked: 1 time
Joined: Nov 16, 2022 7:46 am
Contact:

Re: Minimal permissions on PostreSQL for Veeam Agent to perform backup?

Post by mark1117 »

This is very helpful for me,thanks for your reply.
Mildur
Product Manager
Posts: 8341
Liked: 2171 times
Joined: May 13, 2017 4:51 pm
Full Name: Fabian K.
Location: Switzerland
Contact:

Re: Minimal permissions on PostreSQL for Veeam Agent to perform backup?

Post by 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
Product Management Analyst @ Veeam Software
Post Reply

Who is online

Users browsing this forum: No registered users and 13 guests