If you don't have root command line access in Puppet Enterprise, you can use a task in the
puppetlabs-support_tasks module to run PuppetDB and PostgreSQL query commands from the console. Use these queries to get information about resources, to get the status of replication, PostgreSQL activity, and the PuppetDB service, and to check the size of databases and tables.
Version and installation information
PE version: 2018.1 and later
OS: Any primary server OS
Installation type: Any
Use a task in the
support_tasks module to query the following on the primary server:
- Number of events generated per resource
- Longest resource titles
- PuppetDB service status
- PostgreSQL replication slots
- PostgreSQL replication status
- PostgreSQL activities status
- PostgreSQL database table sizes
- PostgreSQL database sizes
To use the task:
Download and install the
support_tasks module, which includes the task for this solution.
In the console, in the Task field, select
Under Task parameters, select a command to run. If you select
database_table_sizes, you can configure a specific database parameter database to query. If you don’t select one, the command by default queries pe-puppetdb.
Target the primary server node. From the list of target types, select Node list. Expand the Inventory nodes target. Enter the name of the primary server and click Search. From the list of results, select the primary server.
Click Run task. Task output appears in the console.