The /usr/local/pem/bin/backup.sh and /usr/local/pem/bin/restore.sh scripts can be used for backing up and restoring the PostgreSQL Operations database. Run the scripts on the Operations MN under the root user's permissions.
/usr/local/pem/bin/backup.sh [-o output_directory] [-d dbhost] –t db
where the arguments are:
-o output_directory: specify output directory (optional, default, current directory).-d dbhost: specify the Operations database server (optional, default “localhost”).
The Operations MN can run during backup script execution, so backup can be performed on a "live" system without causing business interruptions.
The format of the backup file name is backup-YYYYMMDDhhmm-db.EXT.
YYYYMMDDhhmmis a time stamp which belongs the time of backup was started.EXTis a backup file extension, tar if the-zoption was omitted, tar.gz if the-zoption was specified.