pgjev

Where it runs

Self-hosted PostgreSQL 14–17 with plpython3u. Not Supabase, Neon, or similar managed hosts.

pgjev installs as a PostgreSQL extension. It needs self-hosted PostgreSQL 14, 15, 16, or 17 with the untrusted language plpython3u, and a superuser to run CREATE EXTENSION.

It does not run on Supabase, Neon, or other managed Postgres hosts that withhold superuser or untrusted Python. Those platforms typically cannot load plpython3u. RDS and Aurora are the same class of host unless you control the server and can install the language.

Check the server before you clone anything:

sql
SHOW server_version;
SELECT * FROM pg_available_extensions WHERE name = 'plpython3u';

On Debian and Ubuntu the language is the postgresql-plpython3-NN package (replace NN with the major). EDB and Postgres.app builds include it.

If you only want to try the extension without installing it on a host, use the Docker image. Otherwise continue with Installation.

PreviousIntroductionNextInstallation