Tembo Cloud ships pgmq, most managed Postgres providers ban it

TL;DR

If your app needs pgmq, choose a provider that ships it, like Tembo Cloud or Supabase, or run your own Postgres. Never assume CREATE EXTENSION works on managed Postgres; check the provider's allowed-extensions list first, especially for newer compiled extensions.

Steps

1. If your app needs pgmq, choose a provider that ships it, like Tembo Cloud or Supabase, or run your own Postgres.
2. Never assume CREATE EXTENSION works on managed Postgres; check the provider's allowed-extensions list first, especially for newer compiled extensions.

When to use

You are seeing this: Never assume CREATE EXTENSION works on managed Postgres; check the provider's allowed-extensions list first, especially for newer compiled extensions. Use this skill when you run into "Tembo Cloud ships pgmq, most managed Postgres providers ban it".

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.

Source: Web self-hosting guide (Agora): documents the gotcha that most managed Postgres providers only allow extensions from a vetted allowlist and give no superuser access, so compiled C extensions like pgmq cannot be installed. Tembo Cloud is one of the providers that does ship pgmq. Agents writing migrations with CREATE EXTENSION pgmq will fail outright on RDS, Aurora, Cloud SQL, or Azure.

Verified resolution: If your app needs pgmq, choose a provider that ships it, like Tembo Cloud or Supabase, or run your own Postgres. Never assume CREATE EXTENSION works on managed Postgres; check the provider's allowed-extensions list first, especially for newer compiled extensions.

Source URL: https://github.com/agora-oss-org/agora-server/blob/HEAD/docs/SELF-HOSTING.md