Forum Discussion

Luis3's avatar
Luis3
Level 1
9 months ago

WAL Archive File Protection in NetBackup 9 for PostgreSQL

Hi,
 
In a NetBackup environment for PostgreSQL, I would like to know if it is possible to configure the inclusion of a continuous backup of the WAL archive files in addition to the usual PostgreSQL backup.

In the documentation, it is specified that archiving must be enabled (archive_mode = on), but I haven't seen anywhere that it is specified that these are protected by the backup. Could you confirm if the WAL archives are being saved in the backup?
 
Thanks and regards
  • Hi, 

    Did you manage to find solution for backup of PostgreSQL database. 

    I have setup Datastore policy (Application backup) that run once  a day. However I don't understand how can I backup WAL archives to have Point-in-Time recovery at least for every hour.  

    I think it could be done by exportin WAL archives to some directory, and then backing up this directory with Standard backup policy every hour, but I am worried about storage space that this will require on the NetBackup disks pools/tapes. Also I have to think about how to manage deletion of already backed up logs. 

    If you have found backup solution, could you please share it with me?

    Thank you