Jira (PDB-5454) The pg_trgm postgresql extension is no longer inside the contrib package, but available by default since postgresql version 10

[Koen Dierckx (Jira)]

Title: Message Title

Koen Dierckx updated an issue   PuppetDB / PDB-5454 The pg_trgm postgresql extension is no longer inside the contrib package, but available by default since postgresql version 10 Change By: Koen Dierckx 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 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': }   Create a PR [https://github.com/puppetlabs/puppetlabs-puppetdb/pull/ 348 350 ]     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] Add Comment   This message was sent by Atlassian Jira (v8.20.2#820002-sha1:829506d) -- You received this message because you are subscribed to the Google Groups "Puppet Bugs" group. To unsubscribe from this group and stop receiving emails from it, send an email to puppet-bugs+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/puppet-bugs/JIRA.434971.1644586338000.22681.1645639620039%40Atlassian.JIRA.