Configuring database backups
Description
It is strongly recommended that you configure a database backup storage location that is not local to the NSP cluster. To do so, you must configure NFS using the following parameters in the backups section of the nsp-config.yml file:
Note: If the NFS parameters are configured, the capacity parameter must be unconfigured, as shown below.
storage:
existingClaim: ""
capacity: ""
nfs:
server: "server"
path: "path"
where
server is the NFS server IP address
path is the local path of the exported file system
Reducing backup duration
If the database is large and you have enough storage for intermediate database files, you can performing one of the following to reduce the PostgreSQL backup duration.
-
During installation, add the following in the override values.yaml file in the pg section, backup subsection:
usebasebackup: true
NSP uses the provided storage to store the intermediate files and saves the backup file on the original location.
-
After the installation, set the following in the nspos-postgresql-configmap file:
USEBASEBACKUP:true
In the next scheduled backup, the system uses the optimized backup method.
See “How do I configure scheduled NSP backups?” in the NSP System Administrator Guide for the detailed steps.