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.
-
- Novice
- Posts: 7
- Liked: 1 time
- Joined: Nov 16, 2022 7:46 am
- Contact:
-
- Product Manager
- Posts: 9846
- Liked: 2607 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?
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
Fabian
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
https://www.postgresql.org/docs/current ... point.htmlOnly superusers can call CHECKPOINT.
Best,Only superusers or users with the privileges of the pg_checkpoint role can call CHECKPOINT.
Fabian
Product Management Analyst @ Veeam Software
-
- Novice
- Posts: 7
- Liked: 1 time
- Joined: Nov 16, 2022 7:46 am
- Contact:
Re: Minimal permissions on PostreSQL for Veeam Agent to perform backup?
This is very helpful for me,thanks for your reply.
-
- Product Manager
- Posts: 9846
- Liked: 2607 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?
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
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
Who is online
Users browsing this forum: No registered users and 8 guests