Template:SQWareProduction sqwpg DumpGlobalsOnly.ksh help

From Wiki_dbSQWare
Revision as of 17:02, 6 November 2023 by BatchUser (talk | contribs) (Updated by BatchUser)
Jump to navigation Jump to search
The printable version is no longer supported and may have rendering errors. Please update your browser bookmarks and please use the default browser print function instead.
Sourcing sqwpg_Global.lib v2023.08 SQWareProduction for PostgreSQL (dbSQWare) ... 

Usage: sqwpg_DumpGlobalsOnly.ksh [-h] -I instance [+ options]

DESCRIPTION
   sqwpg_DumpGlobalsOnly.ksh pg_dumpall -g (--globals-only)
SUPPORT
   PostgreSQL supported versions: 9.0 <= v <= 16

PARAMETERS
     -I  instance       : Target instance to pg_dumpall -g (--globals-only).
OPTIONS
     -h    help         : Display the full usage.
     -s                 : Display samples of usage.
     -RD directory      : Directory to write dump file (default /pgbackup/$PG_SID).
     -HI   nb_gen       : Number of generations to keep (default: 2).
     -Opt  option       : Additional options for pg_dumpall.
     -ZIP extension     : Compressor extension gz,bz2,Z,none (default: gz).
     -FRT  return_code  : Force return code value on error.
     -AddMail email     : Email address to add at 'pmexpdba@gmail.com'.
     -SendReport        : Send execution log report.
     -Dist              : For distant connection to database (change $gvsqw_ConnectString to $gvsqw_DistConnectString ).
     -ForceDump         : Force the DUMP even if the cluster is in recovery mode (par defaut, 'Disable').
     -NoForceDump       : don't exec DUMP if the cluster is in recovery mode (par defaut, 'Disable').
     -NoMail            : Deactivate sendmail on error pmexpdba@gmail.com (by default, send on error).
     -Locale   locale   : Force Locale for help display (fr,en).
     -Exec              : Execute commands (default, display generated commands)