Forum Discussion

nerminator's avatar
nerminator
Level 3
2 months ago

PostgreSQL - backup of WAL files

 

Dear community,

I need some help.

I have setup one datastore backup policy that runs Application backup of PostgreSQL database.

Now I am looking in how to manage WAL backups. I need the logs backed up at least once an hour so that I can restore any hour of the day. Meaning hour back if needed.  (Oracle database  backups have intelligent policies to manage backup of logs, but this is not the case for PostgreSQL)

I have thought of creating another Standard policy that will run every hour to backup specific directory where all WAL files will be located. I could use crontab to schedule hourly job that runs bparchive command and set it to automatically delete files that have been backed up.

However, this becomes very difficult to manage on NetBackup and client side, if you plan to have around 500 databases in the future.

Protection plan is a no-go, as it is not very useful and does not allow for customization of SLPs. (meaning you will end up using a lot of disk backup storage)

Has anyone found good solution for backing up PostgreSQL databases?

Thank you for your assistance in this.

Nerm

 

 

No RepliesBe the first to reply