SQWareProduction:postgres:etc:sqwpg CreInst Jobs.cfg

From Wiki_dbSQWare
Revision as of 19:48, 18 January 2013 by BatchUser (talk | contribs) (Updated by BatchUser)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to: navigation, search

Configuration file $gvsqw_PosBin/../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


Retrieved from "https://wiki.dbsqware.com/index.php?title=SQWareProduction:postgres:etc:sqwpg_CreInst_Jobs.cfg&oldid=3574"