Releases and Extensions
Releases
We recommend to deploy the latest available PostgreSQL release for new database projects.
The following table shows the PostgreSQL releases on MPDS:
| ESC Release | PostgreSQL |
|---|---|
| v153 | 13 |
| v153 | 14 |
Extensions (a.k.a. modules)
When deploying an MPDS instance, the following extensions are pre-installed:
- pg_stat_statements (https://www.postgresql.org/docs/current/pgstatstatements.html)
- pgcrypto (https://www.postgresql.org/docs/current/pgcrypto.html)
- uuid-ossp (https://www.postgresql.org/docs/current/uuid-ossp.html)
- auth_delay (https://www.postgresql.org/docs/current/auth-delay.html)
- pgAudit (https://github.com/pgaudit/pgaudit)
There are some extentions which are marked as 'trusted' extension. These extensions can be installed without superuser privileges.
More details about the available extensions can be found here: https://www.postgresql.org/docs/current/contrib.html
'Non-trusted' extensions need further examinations by the engineering team before they can be installed.