Database Backup (for PMP with PostgreSQL)

(Procedure applicable only for builds 6800 and later)

Data stored in PMP database are of critical importance and in any production environment, there would be constant requirements for backing up the data for reference purposes or for disaster recovery. To achieve this, PMP provides the option for backing up the database at periodic intervals.

Scheduled Backup

You can schedule database backup to be executed at any specific point of time.

To schedule database backup,

In the UI that opens up,

To schedule backup in specific day(s) interval,

  1. If your requirement is to backup the database contents in specific day intervals - say, once in three days, this option would come in handy. You can choose any interval between 1 and 28 and also specify the time at which backup has to be taken.
  2. To enable this option, click the radio button "Day"
  3. Select the day interval
  4. Select the time at which backup has to be taken
  5. Backed up data are stored as a .zip file under <PMP_Home>/backUp directory by default. If you want, you can specify the destination directory where you wish to store the backedup contents.
  6. Every time backup is executed, one backup file will be created. You can specify the maximum number of such backup files to be kept in this directory. For example, if you choose "10" in the drop-down against the field "Maintain latest --- backups only", only the latest 10 backup files would be kept under this directory
  7. PMP database is secured through a separate password, which is auto-generated and unique for every installation. The database password can be stored securely in the PMP installation itself. However, for additional security, there is an option to store it at some other secure location accessible to the PMP server. If you select the checkbox "Securely store database password in PMP backup data", it will be securely stored in the backup copy. In case, you decide not to leave the database password to be available with the backup copy, you need to manually copy the database_params.conf file available under the <PMP-Installation-Folder>/conf directory. In the event of restoring the backedup data, you will have to replace the database_params.conf after the restoration process. If you lose this file, data cannot be retrieved from the backup copy. It is pertinent to note that sensitive data are encrypted once in the application (AES 256-bit) and once in database. The application encryption key is also auto-generated and unique for every installation. Hence, even if the database key is allowed to reside along with the backup data, there will not be any security risk as data cannot be deciphered without the application encyption key, which is not available in the backup copy.
  8. Click "Save". The required backup schedule is created

 

  • Where does the backup data get stored? Is it encrypted?
     

All sensitive data in the backup file are stored in encrypted form in a .zip file under  <PMP_Home/backUp> directory or under the directory specified by you. It is recommended that you backup this file in your secure, secondary storage for disaster recovery.
 

  • What is the best option for database backup schedule?
     

Database backup operation is both time and resource consuming. Hence, it is recommended to schedule it to run during off-peak traffic timings. While the operation is in progress, no configuration change could be performed in PMP.

 

  • Can I replicate the data to another server and have the permissions stay intact?

    Yes. PMP application is stateless and all the data are stored in the database and just replicating the database against a fresh installation of the application gets you all the data intact.

 

To schedule backup on a specific day every week,

  1. If your requirement is to backup the database contents on a specific day every week - say, on Mondays, this option would come in handy. You can choose any day from Sunday to Saturday and also specify the time at which backup has to be taken. To enable this option,
  2. click the radio button "Weekly"
  3. select the day of the week
  4. select the time at which backup has to be taken
  5. Backed up data are stored as a .zip file under <PMP_Home>/backUp directory by default. If you want, you can specify the destination directory where you wish to store the backedup contents.
  6. Every time backup is executed, one backup file will be created. You can specify the maximum number of such backup files to be kept in this directory. For example, if you choose "10" in the drop-down against the field "Maintain latest --- backups only", only the latest 10 backup files would be kept under this directory
  7. Click "Save". The required backup schedule is created

To schedule backup on a specific day every month,

  1. If your requirement is to backup the database contents on a specific date every month - say, on 13th, this option would come in handy. You can choose any date from 1st to 31st and also specify the time at which backup has to be taken. To enable this option,
  2. Click the radio button "Monthly"
  3. Select the date of the month
  4. Select the time at which backup has to be taken
  5. Backed up data are stored as a .zip file under <PMP_Home>/backUp directory by default. If you want, you can specify the destination directory where you wish to store the backedup contents.
  6. Everytime backup is executed, one backup file will be created. You can specify the maximum number of such backup files to be kept in this directory. For example, if you choose "10" in the drop-down against the field "Maintain latest --- backups only", only the latest 10 backup files would be kept under this directory
  7. Click "Save". The required backup schedule is created

 


©2014-12, ZOHO Corp. All Rights Reserved.