Database CLI Tool

The smdba tool allows you to manage the installed PostgreSQL database. It allows you to backup and restore the database, as well as administration tasks like creating, verifying, and restarting the database. The tool works on local databases only.

To access a shell inside the Server container, run mgrctl term on the container host. From there, one can run the CLI tools as usual.

The smdba tool replaces the older db-control tool. The db-control tool is now unsupported.

After you stop or restart the database, you need to restart the SUSE Manager services.

Table 1. Database Options
Option	Description
backup-hot	Enable continuous archiving backup
backup-restore	Restore the database from backup.
backup-status	Show backup status.
db-start	Start the database.
db-status	Show database status.
db-stop	Stop the database.
space-overview	Show database space report.
space-reclaim	Free disk space from unused objects in tables and indexes.
space-tables	Show space report for each table.
system-check	Perform a back-end health check.
help	Show help message and exit.

Each option has additional help available. See the help using this syntax:

smdba <OPTION> --help