Database maintenance
You can optimize the Puppet Enterprise (PE) databases to improve performance.
Enable the pe_databases
module
The pe_databases
module helps you manage and tune
your PE databases. The module is installed in the $basemodulepath
directory as part of the PE
installation or upgrade process, and it is enabled by default.
Important: If you have a version of this module, from the Forge or other sources, specified in the code, you
must remove this version before upgrading to allow the version bundled with PE to be asserted.
-
To enable or disable the
pe_databases
module, change thepuppet_enterprise::enable_database_maintenance
parameter. This parameter accepts Boolean values. -
Run Puppet:
puppet agent -t
Databases in Puppet Enterprise
PE uses PostgreSQL as the backend for its databases. Use the native tools in PostgreSQL to perform database exports and imports.
The PE PostgreSQL database includes the following databases:
Database | Description |
---|---|
pe-activity | Activity data from the Classifier, including user, nodes, and time of activity. |
pe-classifier | Classification data, all node group information. |
pe-puppetdb | PuppetDB data, including exported resources, catalogs, facts, and reports. |
pe-rbac | Role-based access control data, including users, permissions, and AD/LDAP info. |
pe-orchestrator | Orchestrator data, including user, node, and result details about job runs. |
List all database names
Use these instructions to list all database names.
To generate a list of database names: