Good morning,
We are new to postgres databases and are implementing our first production cluster soon. What are you all using for your log backups in terms of scheduling? We are running in continuous archive mode and currently have backups every 15 minutes. Even 2G backups are taking under a minute.
What are the considerations for setting this?
If our RPO is 5 minutes, would it make sense to backup every 5 minutes, or is that trying to fit Commvault into a high availability box that it is not designed for?
If using FSBasedBackups, are you also using regularly scheduled dump based backups? In what scenario?
Thank you very much, this forum has been fantastic!
-Chris