Technology upgrade of PostgreSQL
Matillion ETL stores metadata in a database. For GCP and Azure instances on any version of Matillion ETL, and AWS instances of version 1.52 and higher, the database used is PostgreSQL.
PostgreSQL versioning
Read Versioning Policy to learn more about the PostgreSQL versioning policy.
PostgreSQL 9
Matillion ETL versions prior to 1.56 use PostgreSQL version 9 as the metadata database. PostgreSQL 9 was deprecated on 11th November 2021. We recommend that you upgrade to PostgreSQL 16 by following the steps outlined below.
PostgreSQL 13
Matillion ETL versions 1.56 to 1.74 use PostgreSQL version 13 as the metadata database. PostgreSQL 13 went out of support on 13th November 2025. We recommend that you upgrade to PostgreSQL 16 by following the steps outlined below.
PostgreSQL 16
Starting with version 1.75 of Matillion ETL, new instances are shipped with PostgreSQL version 16 as the metadata database.
Steps to update your PostgreSQL database
The path to upgrade differs based on whether Matillion ETL is using an internal or external metadata store.
Please follow the outlined path that applies to you to remain supported:
Internal metadata database
- Relaunch your Matillion ETL deployment using the latest image.
- Read Migration for instructions on migrating your content to your new deployment.
External database
Deployment Type: Existing deployment using external PostgreSQL 9 or 13.
Recommendation: By following the instructions specified by the relevant cloud provider, this deployment will be able to update the PostgreSQL version running RDS/Cloud SQL/Azure Database. Please read the suggested documentation below for each cloud provider:
After following the steps in the relevant cloud provider documentation, Matillion ETL can be upgraded to the latest version.
Amazon RDS for PostgreSQL
As per a post on the AWS Discussion Forums:
"Amazon RDS for PostgreSQL 9.6 will reach end-of-life (EOL) on 18th January, 2022 00:00:01 AM UTC. While you will be able to run your RDS for PostgreSQL 9.6 databases between community PostgreSQL 9.6 EOL (11th November, 2021) and RDS for PostgreSQL 9.6 EOL (18th January, 2022), the databases will not receive any security patches during this extended availability period."
For any Matillion ETL instances that use Amazon RDS for PostgreSQL, please be aware that AWS automatically upgraded all PostgreSQL 9.6 instances to version 12 on or soon after 18th January, 2022.
Matillion strongly recommends you upgrade your PostgreSQL instance to version 16, and upgrade your Matillion ETL instances to version 1.75 or later.
Azure Database for PostgreSQL
As per a post from the Microsoft Azure updates:
"Because PostgreSQL version 9.6 community support ends on 11th November 2021, Azure Database for PostgreSQL no longer supports PostgreSQL version 9.6 after 11th November 2021."
Matillion strongly recommends you upgrade your PostgreSQL instance to version 16, and upgrade your Matillion ETL instances to version 1.75 or later.
GCP Cloud SQL for PostgreSQL
As per a post from Google Cloud:
"The final release for PostgreSQL 9.6 is slated for 11th November, 2021. This is a good time to consider upgrading to a more recent version of PostgreSQL. Cloud SQL for PostgreSQL strives to maintain compatibility with the latest releases and currently supports 10, 11, 12, and 13."
Matillion strongly recommends you upgrade your PostgreSQL instance to version 16, and upgrade your Matillion ETL instances to version 1.75 or later.