PuppetDB requires the pg_trgm extension
The puppetdb module will install this extension with the class puppetdb::database::postgresql
This extension *used* to be provided by a package called postgresql-contrib, and that is installed by the class \{ '::postgresql::server::contrib': }
But this extension is now being bundled with the postgresql package since version 10 , so there is no longer a need to include the contrib package with class \{ '::postgresql::server::contrib': }
FYI
In our case, we have configured the puppetdb module, to use postgresql 13
class { 'puppetdb':
postgres_version => "13",
After applying this manifest, we end up with both postgresql 13 and 14 installed
This is caused by the contrib package pulling in the postgresql package as a dependency
[https://wiki.postgresql.org/wiki/Apt]
_*Note:* This repository provides "postgresql", "postgresql-contrib", and "postgresql-client" meta-packages that depend on the latest postgresql-x.y, ... packages, similar to the ones present in Debian and Ubuntu. Once a new PostgreSQL version is released, these meta-packages will be updated to depend on the new version._
Unfortunately once a new postgresql version is released, there is no longer a meta package for the previous version available in the official postgresql apt repository for postgresql-contrib
And then the install of the postgresql-contrib package will also pull in the latest version of postgresql as its dependency.
So in its core this is a package availability issue on the postgresql side and not a puppetdb issue.
Created an issue for this here [https://redmine.postgresql.org/issues/7169] |
|
|
