You can view information about the backed-up data and the status of the backup process in the FEP server tables and system views.
Backup information is updated when the automatic backup process completes or when backup data is deleted as specified by retention.
The following tables and views are added. The tables and views to be added are created under the fep_exporter schema in the postgres database on the FEP server.
Table/View name | Details |
|---|---|
pgbackrest_info_backup | Backup Processing Status |
Contains one line per backup for information about the state of the backup.
Column | Type | Description |
|---|---|---|
label | text | Information identifying the backup |
type | text | full: full backup, incr: incremental backup |
prior | text | Label of the backup that should be applied first (For incremental backups only) |
database_size | bigint | Database size |
database_size_comp | bigint | Database size (After Compression) |
backup_size | bigint | Backup size |
backup_size_comp | bigint | Backup size (After Compression) |
archive_start | text | Range of WALs required for restore (Start) |
archive_stop | text | Range of WALs required for restore (End) |
backup_start | timestamp with timezon | Backup Start Time |
backup_stop | timestamp with timezone | Backup End Time |
backup_exec_time | interval | The duration of the backup |
