You can optimize the Puppet Enterprise (PE) databases to improve performance.
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:
|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.|
Optimize a database
If your databases are slow, begin taking up too much disk
space, or need general performance enhancements, use the PostgreSQL
vacuum command to optimize any of the PE databases.
su - pe-postgres -s /bin/bash -c "/opt/puppetlabs/server/bin/vacuumdb -z --verbose <DATABASE_NAME>"
List all database names
Use these instructions to list all database names.
To generate a list of database names:
sudo su - pe-postgres -s /bin/bash
Open the PostgreSQL command-line:
List the databases:
Exit the PostgreSQL command line:
Log out of the