postgreSQL + unsupported PostgreSQL versions

Question

we have Ambari Hadoop cluster with postgresql version

postgres -V
postgres (PostgreSQL) 9.2.13

from documentation (https://www.postgresql.org/docs/9.2/release-9-2-13.html) , we can see that version above is unsupported

since Ambari used the PostgreSQL version 9.2.13

I want to understand the meaning of "unsupported version of PostgreSQL"

what is the preferred PostgreSQL version that we need to re-install ?

based on that Ambari version is 2.6.2.1 and on some other cluster we have Ambari version 2.6.1

If that Ambari doesn't support a more recent PostgreSQL version, don't use it. — Laurenz Albe
– Laurenz Albe, Commented Jun 16, 2021 at 10:28
actually I need to verify this from ambari side , I will update this info ,,,, soon — jessica
– jessica, Commented Jun 16, 2021 at 10:30
based on the link docs.cloudera.com/HDPDocuments/Ambari-2.7.1.0/… community.cloudera.com/t5/Support-Questions/… , we can use the latest version as 9.5 — jessica
– jessica, Commented Jun 16, 2021 at 10:45
9.5 is out of support too. Avoid using ill-maintained software like that Ambari. — Laurenz Albe
– Laurenz Albe, Commented Jun 16, 2021 at 11:46

Richard Huxton · Accepted Answer · 2021-06-16 09:43:11Z

Like most projects, the core PostgreSQL team commit to providing security and bug fixes for a set length of time. Verson 9.2 was released in 2012 and has been out of support for a long time now.

https://www.postgresql.org/support/versioning/

If you have a support contract from e.g. Red Hat, they will provide support for whatever version is shipped for whatever duration your contract says.

Now, if you have to run a specific version of Ambari (I don't know what Ambari is I'm afraid) and that only supports certain versions of PostgreSQL you should go for the most recent version you can.

You should always run the most recent minor version though. There is 9.2.24 available so you shouldn't even be looking at 9.2.13 at all.

If you have to run an unsupported version, make sure (1) you understand your systems fully and (2) you have regular, tested backups available and (3) you've tested a backup+restore onto a newer, supported version of PostgreSQL too.

Collectives™ on Stack Overflow

postgreSQL + unsupported PostgreSQL versions

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related