Hello All,
I need to take backup from postgres cluster using Veeam, the postgres is deployed in clustered nodes (3-nodes).
As I know and did it before, we can use Veeam Agent for Linux to backup single node holding the postgres database, then I can perform the restore for the file using Linux FLR.
Here I have some points to be discussed :
1- I know we can perform image-level backup for the VM holding the postgres, and ask the DB admin to provide us pre or post-thau script.
In this cause, would it be better to use Linux agent backup on the VM instead of VM-backup?
What is the pros and cons for using Agent or VM back with postgres?
2- can we create a script from our end as backup admin as simple script if the customer does not have his own script? In this case appreciate if someone explained how the script works?
3- how can we backup clustered machines, do we have to install Linux agent on all cluster nodes? How can I point the nodes to take backup and restore? Comparing to Microsoft SQL Always-on, I do the backup using clustername object in the Ad, how can we do the simlitarity for postgres cluster?
4- for restore, the only possible way right now is restore as file level from the Linux machine, Right? and what about the restore from postgres cluster nodes?
5-As Veeam gurus, Does anyone read about any enhancements in the coming release (V12),we can backup abd restore as database level from postgres, or we will use the same backup and restore mechanisms with 11a.
Many Thanks
