This extension became available as a “trusted” extension on PostgreSQL 13+, where it can be enabled by any users.
Since you are running an older PostgreSQL version, you will have to workaround this, by installing and enabling this extension for the Discourse user, and potentially trying to trick Discourse in considering this extension as already installed. That or moving to the current supported version of PostgreSQL.