Skip to content

backup wal

Jump to bottom
pgrecm edited this page Jan 12, 2022 · 2 revisions

Home - Top

Create a backup of all WAL files, and optionally remove WAL files from directory once backuped.

Options/Qualifiers

/directory="PATH" Set a different location for the current WAL backup
/switch Invoke a switch wal before to start the backup.
By default,a checkpoint is generated.
/nochkpt Disable checkpoint. Ignored if not used with '/switch'.
/delete Force deletion of WAL files after backup, independently of the retention policy.
/nodelete Disable deletion of WAL files after backup, independently of the retention policy.
/lock Exclude backup from the default policy (keep forever).
/tag="..." Change default TAG of the backup
/verbose Change log details.

Description

connection to a DEPOSIT is mandatory.

Example 

CLU12> backup wal /switch /verbose 
recm-inf: Invoking switch WAL (1B/BF000128)
recm-inf: Scanning directory '/Library/PostgreSQL/12/WALfiles'
recm-inf: WAL file '000000230000001B000000B1' already backuped (1)
recm-inf: WAL file '000000230000001B000000B2' already backuped (1)
recm-inf: WAL file '000000230000001B000000B3' already backuped (1)
recm-inf: WAL file '000000230000001B000000B4' already backuped (1)
recm-inf: WAL file '000000230000001B000000B5' already backuped (1)
recm-inf: WAL file '000000230000001B000000B5.00000028.backup' already backuped (1)
recm-inf: WAL file '000000230000001B000000B6' already backuped (1)
recm-inf: WAL file '000000230000001B000000B7' already backuped (1)
recm-inf: WAL file '000000230000001B000000B8' already backuped (1)
recm-inf: WAL file '000000230000001B000000B9' already backuped (1)
recm-inf: WAL file '000000230000001B000000BA' already backuped (1)
recm-inf: WAL file '000000230000001B000000BB' already backuped (1)
recm-inf: WAL file '000000230000001B000000BB.00000028.backup' already backuped (1)
recm-inf: WAL file '000000230000001B000000BC' already backuped (1)
recm-inf: WAL file '000000230000001B000000BD' already backuped (1)
recm-inf: Starting WAL backup of '1B/C0000000'
recm-inf: Copying WAL file '/Library/PostgreSQL/12/WALfiles/000000230000001B000000BE'
recm-inf: Creating piece '/Volumes/pg_backups/000161dc57a81d58a648_1_WAL.recm'
recm-inf: Backup Piece /Volumes/pg_backups/000161dc57a81d58a648_1_WAL.recm FileSize=16630 (Compression ratio: 99.90%)
recm-inf: Backup UID : 000161dc57a81d58a648
recm-inf: Total pieces ......... : 1       
recm-inf: Total files backuped.. : 1       
recm-inf: Total files deleted... : 0        (Files aged 10 minute(s) or more)
recm-inf: Total Backup size .... : 16777216 (16 MB)

CLU12>
Clone this wiki locally