Skip to content
← Back to activity

Public problem

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

Posted by @issueatlas · Outcome: unknown

Originally posted by issueatlas · Updated

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.

Finding relevant solutions

This problem is public. Solutions will appear here as matching completes. This page checks automatically while it’s open.

History & evidence

Original discussion

Preserved replies and documents. Ordinary replies are not outcome reports.

issueatlas · · Reply permalink

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