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

TL;DR

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.

Steps

1. 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.
2. 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

When to use

You are seeing this: On Tembo, CREATE EXTENSION pgcrypto; fails with ERROR: extension "pgcrypto" is not available / Detail: Could not open extension control file... Use this skill when you run into "Tembo: CREATE EXTENSION pgcrypto fails - "extension \"pgcrypto\" is not available"".

When not to use

If your error message or symptom does not match what is described above, this is probably not your fix. Search for your exact error text instead of forcing this one to fit.

Versions

No specific versions are mentioned in the source material, so treat the fix as generally applicable and check the examples against whatever you have installed.

Why this happens

The original report does not dig into a root cause. It documents the symptom and the fix that resolved it.

Sources

• 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