SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg

Fichier de configuration $gvsqw_PgBin/../etc/sqwpg_CreInst_Jobs.cfg:



Contenu du fichier:

#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

#NetBackup: run user backup command
NetBackup:$gvsqw_PgBin/sqwpg_NetBackup.ksh -I <PG_SID> -Policy <Policy> -Schedule  <Schedule> -Exec

#RsyncBackup: run rsync command
RsyncBackup:$gvsqw_PgBin/sqwpg_RsyncBackup.ksh -I <PG_SID> -Exec