Template:SQWareProduction sqwpg PgBackrestAll.ksh help
Jump to navigation
Jump to search
Sourcing sqwpg_Global.lib v2025.11 SQWareProduction for PostgreSQL (dbSQWare) ...
Usage: sqwpg_PgBackrestAll.ksh [-h] -I instance [+ options]
DESCRIPTION
sqwpg_PgBackrestAll.ksh backup all PG clusters with pgbackrest in parallel
SUPPORT
PostgreSQL supported versions: 9.0 <= v <= 18
Before using this script, you must install pgbackrest utilities on your system !
More information on https://pgbackrest.org/
PARAMETERS
-Type type : Type of backup (full,diff,incr).
OPTIONS
-h : Display the full usage.
-s : Display samples of usage.
-P Nb threads : Number of threads in parallel (by default 2).
-AGR Nb_sec : Nb of seconds between two runs (by default 1s).
-AGE Nb_sec : Nb of seconds between two checks of end (by default 10s).
-FRT code : Force return code value on error.
-BkrMode mode : Mode of backup Local or Central (by default, Local)
-AddMail email : Email address to add at 'demo-sqwarebox@dbsqware.com'.
-ListFile filename : File containing the list of clusters(by default /home/dbsqware/sqwConfig/sqwpg_PgbackrestClusters.lst).
-SendReport : Send execution log report.
-Opt option : Additional options for command line
-NoMail : Deactivate sendmail on error demo-sqwarebox@dbsqware.com (by default, send on error).
-Locale locale : Force Locale for help display (fr,en).
-Exec : Execute commands (by default, display generated commands).