3.4.4 SHOW-SERVERS

The SHOW-SERVERS subcommand displays the information for the managed database servers listed in the BART configuration file.

bart SHOW-SERVERS [ –s { server_name | all } ]

The default action is to show all servers.

Options

-s, --server { server_name | all }

server_name is the name of the database server whose BART configuration information is to be displayed. If all is specified or if the option is omitted, information for all database servers is displayed.

Example

The following example shows all database servers managed by BART:

-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"