pe_databasespe_databases::backuppe_databases::maintenancepe_databases::maintenance::pg_repackpe_databases::maintenance::vacuum_fullpe_databases::postgresql_settingspe_databases::postgresql_settings::table_settings
reset_pgrepack_schema: This task will remove and recreate the pg_repack extension
The pe_databases class.
The following parameters are available in the pe_databases class:
manage_database_backupsmanage_database_maintenancemanage_postgresql_settingsmanage_table_settingsinstall_dirscripts_dir
Data type: Boolean
Default value: true
Data type: Boolean
Default value: true
Data type: Boolean
Default value: true
Data type: Boolean
Default value: true
Data type: String
Default value: '/opt/puppetlabs/pe_databases'
Data type: String
Default value: "${install_dir}/scripts"
The pe_databases::backup class.
The following parameters are available in the pe_databases::backup class:
databases_and_backup_schedulepsql_versionbackup_directorybackup_script_pathdaily_databases_pathbackup_logging_directoryretention_policy
Data type: Array[Hash]
Default value: [ { 'databases' => pe_databases::version_based_databases(), 'schedule' => { 'minute' => '30', 'hour' => '22', }, }, { 'databases' => ['pe-puppetdb'], 'schedule' => { 'minute' => '0', 'hour' => '2', 'weekday' => '7', }, } ]
Data type: String
Default value: $pe_databases::psql_version
Data type: String
Default value: "/opt/puppetlabs/server/data/postgresql/${psql_version}/backups"
Data type: String
Default value: "${pe_databases::scripts_dir}/puppet_enterprise_database_backup.sh"
Data type: String
Default value: "${pe_databases::install_dir}/default_daily_databases.txt"
Data type: String
Default value: '/var/log/puppetlabs/pe_databases_backup'
Data type: Integer
Default value: 2
The pe_databases::maintenance class.
The following parameters are available in the pe_databases::maintenance class:
Data type: Boolean
Default value: false
Data type: String
Default value: '/var/log/puppetlabs/pe_databases_cron'
Data type: String
Default value: $pe_databases::scripts_dir
The pe_databases::maintenance::pg_repack class.
The following parameters are available in the pe_databases::maintenance::pg_repack class:
Data type: Boolean
Default value: $pe_databases::maintenance::disable_maintenance
Data type: String
Default value: $pe_databases::maintenance::logging_directory
Data type: Integer
Default value: /
The pe_databases::maintenance::vacuum_full class.
The following parameters are available in the pe_databases::maintenance::vacuum_full class:
Data type: Boolean
Default value: $pe_databases::maintenance::disable_maintenance
Data type: String
Default value: $pe_databases::maintenance::logging_directory
Data type: String
Default value: $pe_databases::maintenance::script_directory
The pe_databases::postgresql_settings class.
The following parameters are available in the pe_databases::postgresql_settings class:
autovacuum_vacuum_scale_factorautovacuum_analyze_scale_factorautovacuum_max_workerslog_autovacuum_min_durationlog_temp_fileswork_memmax_connectionsarbitrary_postgresql_conf_settingscheckpoint_completion_targetcheckpoint_segmentsmanage_postgresql_serviceall_in_one_pe_installmanage_reports_autovacuum_cost_delayfactsets_autovacuum_vacuum_scale_factorreports_autovacuum_vacuum_scale_factormaintenance_work_memautovacuum_work_mempsql_version
Data type: Float[0,1]
Default value: 0.08
Data type: Float[0,1]
Default value: 0.04
Data type: Integer
Default value: max(3, min(8, $facts['processors']['count'] / 3))
Data type: Integer
Default value: -
Data type: Integer
Default value: -
Data type: String
Default value: '8MB'
Data type: Integer
Default value: 1000
Data type: Hash
Default value: {}
Data type: Float[0,1]
Default value: 0.9
Data type: Integer
Default value: 128
Data type: Boolean
Default value: true
Data type: Boolean
Default value: true
Data type: Boolean
Default value: true
Data type: Optional[Float[0,1]]
Default value: 0.80
Data type: Optional[Float[0,1]]
Default value: 0.01
Data type: String
Default value: $all_in_one_pe_install
Data type: String
Default value: $all_in_one_pe_install
Data type: String
Default value: $pe_databases::psql_version
The pe_databases::postgresql_settings::table_settings class.
The following parameters are available in the pe_databases::postgresql_settings::table_settings class:
manage_reports_autovacuum_cost_delayfactsets_autovacuum_vacuum_scale_factorreports_autovacuum_vacuum_scale_factorcatalogs_autovacuum_vacuum_scale_factorcertnames_autovacuum_vacuum_scale_factor
Data type: Boolean
Default value: lookup('pe_databases::postgresql_settings::manage_reports_autovacuum_cost_delay', {'default_value' => true})
Data type: Optional[Float[0,1]]
Default value: lookup('pe_databases::postgresql_settings::factsets_autovacuum_vacuum_scale_factor', {'default_value' => 0.80})
Data type: Optional[Float[0,1]]
Default value: lookup('pe_databases::postgresql_settings::reports_autovacuum_vacuum_scale_factor', {'default_value' => 0.01})
Data type: Optional[Float[0,1]]
Default value: 0.75
Data type: Optional[Float[0,1]]
Default value: 0.75
The pe_databases::set_puppetdb_table_autovacuum_cost_delay_zero class.
The following parameters are available in the pe_databases::set_puppetdb_table_autovacuum_cost_delay_zero defined type:
Data type: String
Default value: $title
The pe_databases::set_table_attribute class.
The following parameters are available in the pe_databases::set_table_attribute defined type:
Data type: String
Data type: String
Data type: String
Data type: String
Type: Puppet Language
The pe_databases::version_based_databases function.
The pe_databases::version_based_databases function.
Returns: Array[String]
This task will remove and recreate the pg_repack extension
Supports noop? false