Operations Database

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.

Restore

/usr/local/pem/bin/restore.sh [-d dbhost] [-F] –f backup_file

where arguments are:

-d dbhost: specify Operations database server (optional, default “localhost”).
-f backup_file: the backup file.
-F (optional) If specified, all existing files will be removed during restoration process. If this option is not specified, the restoration script will refuse to overwrite existing files.

The Operations MN server and all the Operations UI servers must be stopped before restore script execution.

To stop Operations UI servers, execute the following instructions for every Operations UI server:

Log in to Operations UI server through SSH as the root user.
Run this command:
```
service pau stop
```

To stop the Operations MN, complete the following steps:

Log in to Operations MN through SSH as the root user.
Run these commands:
```
service pa-agent stop
service pau stop
```

After that restore process finished, the Operations MN and all the Operations UI servers start.

To start the Operations MN, complete the following steps:

Log in to Operations MN server through SSH as the root user.
Run these commands:
```
service pau start
service pa-agent start
```

To start Operations UI servers, complete the following steps for every Operations UI server:

Log in to Operations UI server through SSH as the root user.
Run this command:
```
service pau start
```