Skip to main content
Version 4.0.0

Backup Execution

This option allows performing backups in online mode (with the database running).

note

Throughout the backup process, transactional logs are continuously generated and stored, enabling point-in-time recovery.

Command Syntax
Terminal input
  pgsmart backup exec [Flags]

Flags:

  • -a, --agent=<agent> => Alias, hostname, or IP of the server where the desired PgSmart Agent is installed.
  • -b, --backup=<value> => Identifier for a specific backup operation. [default: All]
  • -h, --help => Help
  • -j, --job=<value> => Job identifier for tracking backup or restore operations.
  • -o, --only-info => Shows only backup site information. Used with the --quiet option.
  • -p, --no-page-info => Disables pagination of backup site details (used with --quiet).
  • -s, --site=<value> => Backup site name. [default: All]
  • -t, --type=(full|diff|incr) => Backup type. [default: incr]
    • full (Complete) => Backup of all instance files.
    • diff (Differential) => Backup of files changed since the last full backup.
    • incr (Incremental) => Backup of files changed since the last backup, regardless of type.
Non-Interactive Execution
Terminal input
    pgsmart backup exec -a localhost -t [full|incr|diff] --site=<backup-site-name> -q -o -p
Interactive Execution
Terminal input
    pgsmart backup exec

  1. Select the desired PgSmart Agent (or Register a new Agent).

  2. Select the backup site.

note

When selecting the backup site, PgSmart will automatically perform a site verification.

  1. Select the desired backup type : full, incremental, or differential.

    Figure 1 - Backup Execution
    Figure 1 - Backup Execution
Final Notes
note

  • By default, the backup will be generated for all registered repositories. Currently, PgSmart does not support targeting a specific repository for backup, although pgBackRest allows this functionality.

  • This operation will be available soon.