Forge Home

pdb_3323_workaround

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

16,242 downloads

16,242 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.

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.