Difference between revisions of "SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg"
m (Updated by BatchUser) |
m (Updated by BatchUser) |
||
| Line 1: | Line 1: | ||
| − | Configuration file $ | + | Configuration file $gvsqw_PgBin/../etc/sqwpg_CreInst_Jobs.cfg:<br> |
{{SQWareProduction_sqwpg_CreInst_Jobs.cfg_presentation}} | {{SQWareProduction_sqwpg_CreInst_Jobs.cfg_presentation}} | ||
<br> | <br> | ||
Revision as of 20:30, 18 January 2013
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
