SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg: Difference between revisions
Jump to navigation
Jump to search
m Updated by BatchUser |
m Updated by BatchUser |
||
| Line 20: | Line 20: | ||
#Vacuum: Rotate log slow query | #Vacuum: Rotate log slow query | ||
Vacuum:$gvsqw_PgBin/sqwpg_VacuumAllDatabases.ksh -I <PG_SID> -Exec | Vacuum:$gvsqw_PgBin/sqwpg_VacuumAllDatabases.ksh -I <PG_SID> -Exec | ||
#PITR: backup PITR | |||
PITR:$gvsqw_PgBin/sqwpg_BackupPitr.ksh -I <PG_SID> -Exec | |||
</pre> | </pre> | ||
<br> | <br> | ||
Revision as of 10:52, 20 July 2014
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