# Extensions

> [!NOTE]
>
> **Info**
>
> Currently behind [feature flag](<https://documentation.syseleven.de/en/products/dbaas/concepts/features/index.md>).

## Usage

Only trusted extensions are installable by you. A list of possible extensions (versions) can retrieve with:

```sql
SELECT name,version FROM pg_available_extension_versions WHERE trusted = true;
```

Installing extensions:

```sql
CREATE EXTENSION extension_name [ VERSION version ];
```

## Supported extensions

### PostgreSQL 15

Only PostgreSQL \>= 15.16 supports extensions

| Name | Supported Versions |
| :---: | :---: |
| timescaledb | 2.10.3, 2.11.2, 2.12.2, 2.13.1, 2.14.2, 2.15.3, 2.16.1, 2.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.4, 2.22.1, 2.23.1, 2.24.0, 2.25.2, 2.26.4, 2.27.1 |
| pgaudit | 1.7.1 |
| pg\_failover\_slots | 1.2.1 |
| vector | 0.8.2 |
| tds\_fdw | 2.0.5 |
| wal2json | 2.6 |
| postgis | 3.6.3 |
| pg\_uuidv7 | 1.7 |
| pg\_buffercache | 1.3 |
| pg\_trgm | 1.6 |
| amcheck | 1.3 |
| btree\_gin | 1.3 |
| lo | 1.1 |
| pg\_stat\_statements | 1.10 |
| pgrowlocks | 1.2 |
| pgstattuple | 1.5 |

### PostgreSQL 16

Only PostgreSQL \>= 16.12 supports extensions

| Name | Supported Versions |
| :---: | :---: |
| timescaledb | 2.13.1, 2.14.2, 2.15.3, 2.16.1, 2.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.4, 2.22.1, 2.23.1, 2.24.0, 2.25.2, 2.26.4, 2.27.1 |
| pgaudit | 16.1 |
| pg\_failover\_slots | 1.2.1 |
| vector | 0.8.2 |
| tds\_fdw | 2.0.5 |
| wal2json | 2.6 |
| postgis | 3.6.3 |
| pg\_uuidv7 | 1.7 |
| pg\_buffercache | 1.4 |
| pg\_trgm | 1.6 |
| amcheck | 1.3 |
| btree\_gin | 1.3 |
| lo | 1.1 |
| pg\_stat\_statements | 1.10 |
| pgrowlocks | 1.2 |
| pgstattuple | 1.5 |

### PostgreSQL 17

Only PostgreSQL \>= 17.8 supports extensions

| Name | Supported Versions |
| :---: | :---: |
| timescaledb | 2.17.2, 2.18.2, 2.19.3, 2.20.3, 2.21.4, 2.22.1, 2.23.1, 2.24.0, 2.25.2, 2.26.4, 2.27.1 |
| pgaudit | 17.1 |
| pg\_failover\_slots | 1.2.1 |
| vector | 0.8.2 |
| tds\_fdw | 2.0.5 |
| wal2json | 2.6 |
| postgis | 3.6.3 |
| pg\_uuidv7 | 1.7 |
| pg\_buffercache | 1.5 |
| pg\_trgm | 1.6 |
| amcheck | 1.4 |
| btree\_gin | 1.3 |
| lo | 1.1 |
| pg\_stat\_statements | 1.11 |
| pgrowlocks | 1.2 |
| pgstattuple | 1.5 |

### PostgreSQL 18

Only PostgreSQL \>= 18.2 supports extensions

| Name | Supported Versions |
| :---: | :---: |
| timescaledb | 2.23.1, 2.24.0, 2.25.2, 2.26.4, 2.27.1 |
| pgaudit | 18.0 |
| pg\_failover\_slots | 1.2.1 |
| vector | 0.8.2 |
| tds\_fdw | 2.0.5 |
| wal2json | 2.6 |
| postgis | 3.6.3 |
| pg\_uuidv7 | 1.7 |
| pg\_buffercache | 1.6 |
| pg\_trgm | 1.6 |
| amcheck | 1.5 |
| btree\_gin | 1.3 |
| lo | 1.2 |
| pg\_stat\_statements | 1.12 |
| pgrowlocks | 1.2 |
| pgstattuple | 1.5 |

## Requesting additional extensions

If you require further extensions (versions) please open a [support ticket](<https://helpdesk.syseleven.de>) with us and we will verify possibility.
