Template:SQWareProduction sqwpg PgBackrestAll.ksh help
		
		
		
		Jump to navigation
		Jump to search
		
Sourcing sqwpg_Global.lib v2025.10 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 <= 17
    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).