gpdr info

Retrieve information about all backups, restored backups, and restore points in the repository.

Synopsis

gpdr info backup [--after-timestamp <string>] [--before-timestamp <string>] [--detail] [--format <format>]

gpdr info restore

gpdr info { -h | --help }

Description

The gpdr info backup command displays information about backups that were created on the primary cluster. Depending on the option passed in, it can displays restore points created before or after a particular timestamp, can display output as either restore points or backup labels, and can display less or more detail about backups.

The gpdr info restore command displays information about the most recent successful restore on the recovery cluster. The information provided includes:

• The restore type (full, incremental, or continuous)
• The name of the restore point
• The backup label
• The time the restore started
• The time the restore stopped
• If the recovery cluster has not yet been promoted, this command also displays the latest archived WAL and the last replayed WAL for the restore point, and the lag, -- in number of files -- between files replayed and files archived, by segment

Options

--after-timestamp string

Optional. When invoked, gpdr info backup displays restore points created after the specified timestamp (inclusive). The timestamp should be in the format YYYYMMDD-HHMMSS.

--before-timestamp string

Optional. When invoked, gpdr info backup displays restore points created before the specified timestamp (inclusive). The timestamp should be in the format YYYYMMDD-HHMMSS.

--detail

Optional. When invoked, gpdr info backup displays a detailed view of backups. The additonal infomation provided in the detailed view includes timestamp information for when the backup started and stopped, the database size, and the backup size.

--format format

Optional. Specifies the output format. The choices are backups -- to list full backups with their underlying incremental backup(s) and restore points -- and restore-points to list restore points with their respective backups. The default is backups.

-h | --help

Displays a help message for the gpdr info command.

Examples

View information about backups:

Backup-centric view (the default):

$ gpdr info backup

Restore-points-centric view:

$ gpdr info backup --format restore-points

Filtered based on timestamps:

All backups taken after April 20, 2022 at 20220422-000000

$ gpdr info backup --after-timestamp 20220422-000000

All backups taken before June 05, 2022 at 20220605-000000

$ gpdr info backup --before-timestamp 20220605-000000

View information about restores:

$ gpdr info restore

See Also

gpdr