In #2846994: Increase minimum version requirement for Postgres to 10 and require the pg_trgm extension → was the policy decision made that the pg_trgm extension was required. To use an extension on PostgreSQL, the extension must also be created. To be able to create an extension one must have superuser privileges.
Add the requirement for PostgreSQL that the pg_trgm extension is not only installed, but also created.
Make the policy decision and create an new CR.
None
None
None
PostgreSQL requires that the pg_trgm extension is installed and created.
Fixed
10.0 ✨
Particularly affects sites running on the PostgreSQL database.
Not all content is available!
It's likely this issue predates Contrib.social: some issue and comment data are missing.
I opened a follow-up to consider automatically installing pg_trgm in PostgreSQL 13+ databases, where it is considered a "trusted extension" and does not require superadmin privileges to install:
✨
Automatically install pg_trgm extension on PostgreSQL 13+
Fixed