Hello all! We are working on PostreSQL implementation process. Our customer wants to have this kind of schedule:
Log Backup Schedule = Every 2 hours
Schedule = 1 x full 6 x incr,
So we have done that schedule:
For LOG backup:
There is “incremental” chosen and Data is NOT chosen
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/75178ab7-224b-458d-9799-17cd9f8e9863.png)
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/607685c7-f63e-43c9-b937-2a815a7dc654.png)
Other schedule is created for “incremental” backup:
There is “incremental” chosen and Data IS chosen
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/7113f679-118d-4dde-b718-d1df30a9f382.png)
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/cc992165-8e48-4ac8-9311-cee43661429b.png)
When i do run this schedule manually or even if it runs automatically, i can see only this:
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/fe0347af-623f-4626-a240-df35e3f16821.png)
so no matter which schedule run JobType is always “Log Only”
If I do run manually backup and chose incremental, it also uses “Log Only” job type.
This backup is based on FSBasedBackupSet
So if it is even a way to do a normal Incremental backup for PostgreSQL? Or it will always be “log only”?
While running Full backup i can see that there are also logs and Full backup:
![](https://uploads-eu-west-1.insided.com/commvault-eu/attachment/362f2ce0-c2d7-4bda-89c0-d7aa5fc8dc58.png)
I am wondering, hot to handle backup retentions if there is nothing like “straight forward incremental backup”