Version 3.1.1

Metadata Database Management

The Metadata Database is an internal PostgreSQL instance, used solely to store metadata for the observability service.

Check below for the commands available to control the Metadata Database service.

Prerequisites

Terminal input

pgsmart obs metadb[OPERATION] [FLAGS]

Command Syntax

pgsmart obs metadb [OPERATIONS] [FLAGS], as follows:

Operations:

Flags:

-a, --agent=@!<agent>@! => Alias, hostname, or IP of the server where the desired PgSmart Agent is installed.
-h, --help => Help
-q, --quiet => Non-interactive execution for controlling the Metadata Database service (status|start|stop|restart|reload).

Non-Interactive Execution

Terminal input

    pgsmart obs metadb [status|start|stop|restart|reload] -q -a @!&lt;agent&gt;@!

Interactive Execution

Status of the Metadata Database Service

Terminal input

    pgsmart obs metadb status

Select the PgSmart Agent or register a new one.

Figure 1 - Metrics Exporter - metadb - Status

Terminal input

    pgsmart obs metadb stop

Select the PgSmart Agent or register a new one.

Figure 2 - Metrics Exporter - metadb - Stop

Terminal input

    pgsmart obs metadb start

Select the PgSmart Agent or register a new one.

Figure 3 - Metrics Exporter - metadb - Start

Terminal input

    pgsmart obs metadb restart

Select the PgSmart Agent or register a new one.

Figure 4 - Metrics Exporter - metadb - Restart

Terminal input

    pgsmart obs metadb reload

Select the PgSmart Agent or register a new one.

Figure 5 - Metrics Exporter - metadb - Reload