HDF-3.5.2.63 compatibility with postgres15

[#1]

Hello, 

We have HDF 3.5 cluster, where we have Kafka and Nifi. We are using postgres12 for Ambari, Ranger, Schema Registry. Now we are asked to migrate to postgres 14 or 15. Can you please suggest if we can migrate? Our concern is on HDF3.5 compatibility with postgres 14 or 15. If it is OK to migrate, any configuration updates required at cluster.
Need your inputs here please.

Thanks & Regards,

Anil

[#2]

@HiAnil 

HDF 3.5 release is based off Apache NiFi 1.12 and was released more then 5 years ago.   It was End-Of-Life as of April 2023.  

NiFi-Registry service in HDF 3.5.2 only lists PostgreSQL 9.5+, 10.x, and 11.x as tested versions.
I can tell you that HDF 3.5.2 has never been tested or verified against Postgres 14 or 15 and suspect there could likely be incompatibility issues.  I would suggest testing this your self before upgrading in any production environment.

Keep in mind that using such an old release exposes you to CVEs addressed in the many releases put out since HDF 3.5.2.   Additional the product has had many improvements and new features added over the years.

Please help our community thrive. If you found any of the suggestions/solutions provided helped you with solving your issue or answering your question, please take a moment to login and click "Accept as Solution" on one or more of them that helped.

Thank you,
Matt