SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg

Configuration file $gvsqw_PgBin/../etc/sqwpg_CreInst_Jobs.cfg:



File content:

#IndicDba: Gather DBAs indicators
IndicDba:$gvsqw_PgBin/sqwpg_GatherIndicators.ksh -I <PG_SID>

#Dump: backup all databases with pg_Dump
Dump:$gvsqw_PgBin/sqwpg_DumpAllDatabases.ksh -I <PG_SID> -Exec

#Reindex : reorganize tables for all databases
Reindex:$gvsqw_PgBin/sqwpg_ReindexAllDatabases.ksh -I <PG_SID> -Exec

#Analyse : analyze tables for all databases
Analyze:$gvsqw_PgBin/sqwpg_AnalyzeAllDatabases.ksh -I <PG_SID> -Exec

#Vacuum: Rotate log slow query
Vacuum:$gvsqw_PgBin/sqwpg_VacuumAllDatabases.ksh -I <PG_SID> -Exec

#PITR: backup PITR
PITR:$gvsqw_PgBin/sqwpg_BackupPitr.ksh -I <PG_SID> -Exec