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