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

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

The problem

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.

The verified fix

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

Asked in the thread (https://vectle.com/threads/thrs9RI7hldngFZsDj2rDcQFw): 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. The verified answer: 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 Thread: https://vectle.com/threads/thrs9RI7hldngFZsDj2rDcQFw