3.2. Backing up an Embedded Database
db-controlcommand provides features to create, verify, and restore backups, to obtain database status information and to restart the database when necessary. See the
db-controlmanual page (
man db-control) for a full listing of the features available.
3.2.1. Performing Online Database Backups
db-controlcommand make this functionality possible.
online-backup FILENAME:Performs an online backup of the Satellite database (embedded PostgreSQL only).
reset-password:Resets the user password and unlocks the account.
restore DIRECTORY | FILENAME:Restores the database from either:
- An offline backup taken by
db-controland saved in the DIRECTORY directory. The database must be stopped for both the
restoreoperations in order to run successfully.
- An online backup taken by
db-controland saved as FILENAME. The database itself must be running for both the
restoreoperations in order to run successfully, but all other Satellite services must be stopped.
22.214.171.124. Performing an Online Backup
FILENAMEoption with the full path to the backup file that you want to create. This location needs to be writable by the PostgreSQL user:
126.96.36.199. Restoring a Database from an Online Backup
db-controlcommand to restore an embedded database from a backup created using the
db-controlcommand. Before you restore a database, you need to shut down all Satellite services except the database itself.
Procedure 3.1. To Restore a Database from an Online Backup:
- Change to the root user, and run the following command to stop all Satellite services except the database:
- Run the following command to restore the database. Replace the
FILENAMEoption with the full path to the backup file created with the
- After the restoration is complete, run the following command to restart the database and all related services: