Modèle:SQWareProduction sqwpg GlobalVar.cfg explanation
Explication de variables:
#General variables gvsqw_SqwVersion => SQWare Production version gvsqw_SuppArchAlert => number of days to delete archives of alert files gvsqw_SuppArchSlow => number of days to delete archives of slow query files gvsqw_RootAdmin => admin directory gvsqw_RootCfg => configuration directory gvsqw_RootDbf => datafiles directory gvsqw_RootLog => logfile directory gvsqw_PostgresErrorMsg => format of MySQL errors gvsqw_ConnectString => XXXXX gvsqw_DistConnectString => XXXXX gvsqw_RootAdminDisable => XXXXX gvsqw_RootAdminDist => XXXXX gvsqw_PGPASSFILE => path file for pgpass gvsqw_NbThreadVacuum => XXXXX gvsqw_PgDefaultExcludeDb => XXXXX gvsqw_PgDefaultSortDb => XXXXX gvsqw_DbAlias => Database Alias #for Dump scripts gvsqw_NbThreadDump => default number of thread for parallelism for pg_Dump gvsqw_RootDump => default pg_Dump directory gvsqw_DumpNbGeneration => default number generation of pg_Dump to keep online gvsqw_PgDumpOpt => postgres Dump command gvsqw_DumpCompressorExt => XXXXX gvsqw_DumpFormat => XXXXX #for archive pg_xlog script gvsqw_ArchiveXlog_dest1 => XXXXX gvsqw_ArchiveXlog_enabled => XXXXX gvsqw_ArchiveXlogCompressorExt => XXXXX gvsqw_ArchiveXlogMaxMail => XXXXX #for PITR scripts gvsqw_RootPitr => XXXXX gvsqw_PitrNbGeneration => XXXXX gvsqw_PitrCompressorExt => XXXXX gvsqw_PgPitrOpt => XXXXX gvsqw_PitrWaitTimeOut => XXXXX gvsqw_PitrAutoStartSqwArchmon => XXXXX gvsqw_PitrArchLogsTimeTreshold => XXXXX gvsqw_PitrArchLogsInterval => XXXXX gvsqw_ArchiveXlog_dest1_threshold => XXXXX #for indicators gvsqw_SizeMinTableIndicators => Size min in Meg of table to insert into SQWare Repository gvsqw_GenExcludeDatabasesObjects => XXXXX gvsqw_GenExcludeDatabasesObjectsExtra => XXXXX #for optimize scripts gvsqw_NbThreadReindex => default number of thread for parallelism for optimize #for analyse scripts gvsqw_NbThreadAnalyze => default number of thread for parallelism for analyse ##Globaly forcing return code for scripts gvsqw_ForcedReturnCodeScript_sqwpg_DumpDatabase => To force return code of sqwpg_DumpDatabase.ksh ... #for SQWare Web gvsqw_WebDbaUserConn => Connection string ssh user@hostname to SQWare Web gvsqw_WebDbaDirSlowQuery => Directory to store SlowQuery files on SQWare Web