PostgreSQL 14.9 FAQ for upgrades to 2023.04 or newer
The FAQ in this section mainly focuses on the upgrade of PostgreSQL to version 14.9 in your cloud environments. You can find the FAQ of the PostgreSQL upgrade in your on-premises environments on this page.
Why are we upgrading PostgreSQL?
PostgreSQL releases new major versions every year and provides updates for each major version for five years, after which support for fixes ends. Our cloud solution Collibra Platform currently uses PostgreSQL version 11.17, for which support will end on November 9, 2023.
What is the impact on my cloud environment after November 9, 2023?
None. The PostgreSQL version in your 2023.03 or older cloud environments will still work beyond November 9, 2023 but after this date, there will be no further updates for PostgreSQL, not even for critical security issues.
What is the timeline for the upgrade to PostgreSQL 14.9?
The PostgreSQL 14.9 upgrade will be generally available on April 23, 2023 as part of the 2023.04 release and deployed to all customers who upgrade.
What are the implications of waiting beyond PostgreSQL 11 end-of-life (EOL)?
In the event of a functional bug or security vulnerability, the PostgreSQL community is not going to backport a fix/patch to version 11.
Which Collibra Platform environments are impacted?
Collibra Platform 2023.03 is the last version that uses PostgreSQL 11. Collibra 2023.04 or newer makes use of PostgreSQL 14.9. We do not support PostgreSQL 14.9 on Collibra 2023.03 or older.
Is it mandatory to upgrade to Collibra Platform 2023.04?
No. You can create a support ticket to opt out from the 2023.04 release as in the regular release schedule.
Which on-premises Jobserver do I use?
To avoid any future PostgreSQL upgrade scenarios, we strongly recommend that you migrate from Jobserver to Edge.
If you decide to keep using an on-premises Jobserver, the compatibility between your cloud environment and that Jobserver remains as is. An on-premises Jobserver is always compatible until the next quarterly cloud release. This means that for 2023.04, you can still use the on-premises Jobserver 2023.02. However, we will release a 2023.04 Jobserver-only installer. This version is identical to the 2023.02 version but uses PostgreSQL 14.9 instead of PostgreSQL 11.
For the on-premises Jobserver compatibility, go to the Jobserver compatibility page.
What is the feature compatibility between cloud and on-premises environments?
The on-premises Collibra Data Governance Center 5.7.13 is feature compatible with the cloud Collibra Platform 2022.05. The on-premises version 5.9.0 is identical to 5.8.2 but makes use of PostgreSQL 14.9 and includes extra bug fixes. Version 5.8.2 on its turn is identical to 5.7.13 but makes use of PostgreSQL 11 and includes extra bug fixes.
For the feature compatibility of older on-premises versions, go to the compatibility page.
Can I restore backups from on-premises environments in my cloud environment?
Yes, but keep the version compatibility in mind.
- You can restore a 5.7.13 backup only on 2022.05 cloud environments or newer.
- You can restore a 5.8.x backup only on 2022.12 (on-demand version) cloud environments or newer.
- You can restore a 5.9.0 backup only on 2023.04 cloud environments or newer.
For the backup compatibility of older versions, go to the compatibility page.
Following this upgrade, will customers using Jobserver be responsible for subsequent PostgreSQL upgrades?
Future PostgreSQL upgrades will follow the same process. Collibra drives the cadence to upgrade PostgreSQL as it is tied to our releases.