SHOW-SERVERS v2.6
The SHOW-SERVERS subcommand displays information for the managed database servers listed in the BART configuration file.
Syntax:
bart SHOW-SERVERS [ –s { <server_name> | all } ]The following table describes the SHOW-SERVERS option:
| Option | Description |
|---|---|
-s { <server_name> | all }--server { <server_name> | all } | <server_name> is the name of the database server to which the SHOW-SERVERS actions are to be applied.If all is specified or if the -s option is omitted, the actions are applied to all database servers. |
Example
The following code sample shows all the database servers managed by BART as returned by the SHOW-SERVERS subcommand:
-bash-4.2$ bart SHOW-SERVERS SERVER NAME : acctg BACKUP FRIENDLY NAME: acctg_%year-%month-%dayT%hour:%minute HOST NAME : 127.0.0.1 USER NAME : enterprisedb PORT : 5444 REMOTE HOST : RETENTION POLICY : 6 Backups DISK UTILIZATION : 0.00 bytes NUMBER OF ARCHIVES : 0 ARCHIVE PATH : /opt/backup/acctg/archived_wals ARCHIVE COMMAND : (disabled) XLOG METHOD : fetch WAL COMPRESSION : disabled TABLESPACE PATH(s) : INCREMENTAL BACKUP : DISABLED DESCRIPTION : "Accounting" SERVER NAME : hr BACKUP FRIENDLY NAME: hr_%year-%month-%dayT%hour:%minute HOST NAME : 192.168.2.24 USER NAME : postgres PORT : 5432 REMOTE HOST : postgres@192.168.2.24 RETENTION POLICY : 6 Backups DISK UTILIZATION : 0.00 bytes NUMBER OF ARCHIVES : 0 ARCHIVE PATH : /opt/backup/hr/archived_wals ARCHIVE COMMAND : (disabled) XLOG METHOD : fetch WAL COMPRESSION : disabled TABLESPACE PATH(s) : INCREMENTAL BACKUP : DISABLED DESCRIPTION : "Human Resources" SERVER NAME : mktg BACKUP FRIENDLY NAME: mktg_%year-%month-%dayT%hour:%minute HOST NAME : 192.168.2.24 USER NAME : repuser PORT : 5444 REMOTE HOST : enterprisedb@192.168.2.24 RETENTION POLICY : 6 Backups DISK UTILIZATION : 0.00 bytes NUMBER OF ARCHIVES : 0 ARCHIVE PATH : /opt/backup/mktg/archived_wals ARCHIVE COMMAND : (disabled) XLOG METHOD : fetch WAL COMPRESSION : disabled TABLESPACE PATH(s) : INCREMENTAL BACKUP : DISABLED\ DESCRIPTION : "Marketing"