Forge Home

pdb_3323_workaround

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

16,334 downloads

16,334 latest version

4.6 quality score

We run a couple of automated
scans to help you access a
module's quality. Each module is
given a score based on how well
the author has formatted their
code and documentation and
modules are also checked for
malware using VirusTotal.

Please note, the information below
is for guidance only and neither of
these methods should be considered
an endorsement by Puppet.

Support the Puppet Community by contributing to this module

You are welcome to contribute to this module by suggesting new features, currency updates, or fixes. Every contribution is valuable to help ensure that the module remains compatible with the latest Puppet versions and continues to meet community needs. Complete the following steps:

  1. Review the module’s contribution guidelines and any licenses. Ensure that your planned contribution aligns with the author’s standards and any legal requirements.
  2. Fork the repository on GitHub, make changes on a branch of your fork, and submit a pull request. The pull request must clearly document your proposed change.

For questions about updating the module, contact the module’s author.

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.

Download

Documentation

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.