You can optimize the Puppet Enterprise (PE) databases to improve performance.
pe_databases module helps you manage and tune
your Puppet Enterprise (PE) databases. The module is installed in the
$basemodulepath directory as part of the PE installation or upgrade process, and it is enabled by
Important: If you have a version of this module, from the Forge or other sources, specified in your code, you must remove this version before upgrading to allow the version bundled with PE to be asserted.
To enable or disable the
pe_databasesmodule, change the
puppet_enterprise::enable_database_maintenanceparameter. This parameter accepts Boolean values.
puppet agent -t
Databases in PE
Puppet Enterprise (PE) uses PostgreSQL as the backend for its databases. You can use the native tools in PostgreSQL to perform database exports and imports.
The PE PostgreSQL database includes the following databases:
||Activity data from the Classifier, including users, nodes, and times of activities|
||Classification data, all node group information|
||PuppetDB data, including exported resources, catalogs, facts, and reports|
||Role-based access control (RBAC) data, including users, permissions, and AD/LDAP information|
||Orchestrator data, including user, node, and job run result details|
List all database names
You can generate a list of PostgreSQL database names.
Switch to the
pe-postgresuser by running:
sudo su - pe-postgres -s /bin/bash
Open the PostgreSQL command-line by
To list the databases, run:
To exit the PostgreSQL command line, run:
To log out of the