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

[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 Change By: Koen Dierckx Currently PuppetDB requires the pg_trgm extension from the postgresql-contrib package.  The puppetdb module will install this extension with the class puppetdb::database::postgresql This extension is *used* to be provided by a package called postgresql-contrib, and that is installed by class the   class \{ ':: postgresql::server::contrib ': } The But this extension is now being bundled with the postgresql package , so there is called no longer a need to include the contrib package with class \{ ':: postgresql - ::server:: contrib (on Ubuntu ) ': }   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.   In our case, we have configured the puppetdb module, to use postgresql 13 class { 'puppetdb':   postgres_version => "13", But on the server, we now have both postgresql 13 and 14 installed   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]   But perhaps the pg_trgm functionality can be dropped/replaced ? And that would drop the need for the postgresql-contrib package And that avoids the entire dependency issue 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.14435.1644591840046%40Atlassian.JIRA.