Forge Home


A puppet module to create an index that provides a short-term workaround to PDB-3323


15,972 latest version

4.6 quality score

Version information

  • 1.0.1 (latest)
released Mar 8th 2017
This version is compatible with:
  • Puppet Enterprise >= 2016.5.0
  • , , , ,

Start using this module

  • r10k or Code Manager
  • Bolt
  • Manual installation
  • Direct download

Add this module to your Puppetfile:

mod 'puppetlabs-pdb_3323_workaround', '1.0.1'
Learn more about managing modules with a Puppetfile

Add this module to your Bolt project:

bolt module add puppetlabs-pdb_3323_workaround
Learn more about using this module with an existing project

Manually install this module globally with Puppet module tool:

puppet module install puppetlabs-pdb_3323_workaround --version 1.0.1

Direct download is not typically how you would use a Puppet module to manage your infrastructure, but you may want to download the module in order to inspect the code.



puppetlabs/pdb_3323_workaround — version 1.0.1 Mar 8th 2017

How to use

Classify the node running PostgreSQL in your PE deployment with the pdb_3323_workaround class.

The next time the puppet agent runs on that node you should see the following change.

Notice: /Stage[main]/Pdb_3323_workaround/Pdb_3323_workaround::Create_index[pdb_3323_idx_reports_hash]/Pdb_3323_workaround_postgresql_psql[Create index pdb_3323_idx_reports_hash]/command: command changed 'notrun' to 'CREATE INDEX pdb_3323_idx_reports_hash ON reports(hash)'

What is the purpose of this module?

If you are affected by PDB-3323 then this module creates an index that provides a short-term workaround to the issue.

The advantage of this module over creating the index manually is that this module ensures the index is dropped when you upgrade to a version of PE that addresses the issues directly.

You can safely classify this module to your pe-postgresql node and never think about it again. Although, someday you may prefer to remove the module altogether.