https://github.com/aws/pg_tle/
pg_tle (Trusted Language Extensions (TLE) for PostgreSQL) is an open source project that lets developers extend and deploy new PostgreSQL functionality with lower administrative and technical overhead. Developers can use Trusted Language Extensions for PostgreSQL to create and install extensions on restricted filesystems and work with PostgreSQL internals through a SQL API. gives capability to users to launch
The PostgreSQL RPM repository uses PostgreSQL version numbers in the RPM packages. For example pg_tle for PostgreSQL 17 is named as pg_tle_17. Similarly pg_tle for PostgreSQL 15 is named as pg_tle_15.
pg_tle provides the following subpackages:
Install PGDG repository from: https://yum.postgresql.org/repopackages/
| OS | Command |
|---|---|
| RHEL / Rocky Linux / AlmaLinux / Fedora | dnf install pg_tle_17 (or change the version as described above) |
pg_tle requires to be added to shared_preload_libraries
before creating the extension. This requires a restart of the PostgreSQL
instance to take effect. If there are additional libraries, please be sure to
add them as a comma-separated list. An example is:
shared_preload_libraries="pg_tle"
You can create the extension after restarting the instance. Connect to the database that
you want to create the extension as superuser and run:
CREATE EXTENSION pg_tle;
| PostgreSQL version(s) | OS version | Arch | Status |
|---|---|---|---|
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 9 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | RHEL / Rocky Linux / AlmaLinux 8 | x86_64, aarch64 | Available |
| 17,16,15,14,13 | Fedora Linux | x86_64 | Available |