CA API Developer Portal: Backing up the PostgreSQL database

Document ID : KB000100480
Last Modified Date : 07/06/2018
Show Technical Document Details
Issue:
In Portal 4.2.5 scripts were introduced to backup and restore the internal database. 
Earlier versions did not include the scripts and you would like to be able to perform this operations.
Resolution:
The provided scripts in 4.2.5 make use of the PostgreSQL pg_dumpall command. The same script can be utilized on 4.2 installations to backup the database. 
Copies of the backup and restore scripts have been attached here.
 
File Attachments:
scripts.zip