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