Solved

Postgres Backups Split over 2 Storage Policies

Forum|Forum|3 years ago
July 26, 2023
1 reply
51 views

Forum|alt.badge.img

+7

Kiwi_Dave
Novice

Recently I have noticed that a number of our Postgress backups have their log file backups writing to a different Storage Policy from the data backups. If I change the log file backups to the same Storage Policy as the Data backups will this cause any problems.

Best answer by Sunil

Hi @Kiwi_Dave

Having separate storage policies for Data and Archive log backups is a flexibility that the product offers in cases like when you want

To use a fast access library like a disk library for your frequent log backups.
To have different retention for archive log backups than your data backups.

If you don’t have any such requirements, it is perfectly fine to use the same storage policy for both data and log backups.

Thanks,

Sunil-

Forum|alt.badge.img

+16

Sunil
Vaulter
Answer
Forum|Forum|3 years ago
July 27, 2023

Hi @Kiwi_Dave

Having separate storage policies for Data and Archive log backups is a flexibility that the product offers in cases like when you want

To use a fast access library like a disk library for your frequent log backups.
To have different retention for archive log backups than your data backups.

If you don’t have any such requirements, it is perfectly fine to use the same storage policy for both data and log backups.

Thanks,

Sunil-

Like