Tembo: CREATE EXTENSION pgcrypto fails — "extension \"pgcrypto\" is not available"

On Tembo, CREATE EXTENSION pgcrypto; fails with ERROR: extension "pgcrypto" is not available / Detail: Could not open extension control file ... No such file or directory / Hint: The extension must first be installed on the system where PostgreSQL is running. Extensions must be installed into the Tembo instance before CREATE EXTENSION works.

Install it via the Tembo UI first: Extensions → Explore → search for pgcrypto → Install Extension, then Enable Extension. Install Extension pulls the extension from pgt.dev into your Postgres cluster; Enable Extension then runs CREATE EXTENSION for you. The reporter confirmed this worked. Source: https://github.com/tembo/tembo/issues/1029

Source: https://github.com/tembo/tembo/issues/1029