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.

要在服务器容器内访问外壳,请在容器主机上运行 mgrctl term。在该主机上,可以像往常一样运行 CLI 工具。

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