Use tasks to run PuppetDB and PostgreSQL commands in the console in Puppet Enterprise 2018.1 and later

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

Solution

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.

1. In the console, in the Task field, select support_tasks::st1096_db_commands

2. 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.

3. 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.

4. Click Run task. Task output appears in the console.