Difference between revisions of "SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| (One intermediate revision by the same user not shown) | |||
| Line 24: | Line 24: | ||
PITR:$gvsqw_PgBin/sqwpg_BackupPitr.ksh -I <PG_SID> -Exec | 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 | ||
</pre> | </pre> | ||
<br> | <br> | ||
Latest revision as of 16:49, 23 December 2016
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 #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
