The "puppetlabs-pe_databases" module causes a “/Stage[main]/Pe_databases” error message on the PE-PostgreSQL node when upgrading to the latest version of Puppet Enterprise

If you have Puppet Enterprise 2019.8.8 or prior or PE 2021.3, your version of the puppet-pe_databases module causes an error message on the PE-PostgreSQL node when upgrading PE.

Error message

Message: Running puppet failed on host with certname <replica_host>. Output: Info: Using environment 'production'

Info: Retrieving pluginfacts
Info: Retrieving plugin
Info: Loading facts
Info: Caching catalog for tdcr-spupmd01.test.lab
Info: Applying configuration version '<primary_host>-production-4f2a4f96efb'

Notice: /Stage[main]/Eh_puppet_agent::Service/Service[puppet]/ensure: ensure changed 'stopped' to 'running' (corrective)
Info: /Stage[main]/Eh_puppet_agent::Service/Service[puppet]: Unscheduling refresh on Service[puppet]
Error: /Stage[main]/Pe_databases::Postgresql_settings::Table_settings/Pe_databases::Set_table_attribute[Set autovacuum_vacuum_scale_factor=0.8 for factsets]/Postgresql_psql[Set autovacuum_vacuum_scale_factor=0.80 for factsets]: Could not evaluate: Error evaluating 'unless' clause, returned pid 17334 exit 2: 'psql: could not connect to server: No such file or directory

Is the server running locally and accepting connections on Unix domain socket "/var/run/puppetlabs/postgresql11/.s.PGSQL.5432"?

You get this error message after a Puppet run on the PE-PostgreSQL node when upgrading from a version of PE 2019.8.8 or prior or PE 2021.3.

Version and installation information

PE version: Puppet Enterprise 2019.8.8 or prior, or PE 2021.3.

Solution

Uninstall the puppet-pe_databases module from PE to resolve the error message and upgrade PE.

Before you begin

Remove the pe_databases class from classification in PE using the steps in our documentation.

Uninstall the module

Remove the module from PE on the command line or update your Puppetfile.

To uninstall the module on the command line, use the steps in our documentation.

To remove the module using Code Manager, follow these steps:

1. Remove an entry such as mod puppetlabs-pe_databases, 1.1.0 from your Puppetfile.
2. Deploy the code to your environment.

After removing the module, upgrade PE using the steps in our documentation.