1

I am trying to install PostgreSQL server on my CentOS machine. From what I read here (https://www.postgresql.org/docs/current/static/upgrading.html) It seems like Postgres does not guarantee backward compatibility of its files. When I checked CentOS base repo, it said the current version of postgresql-server is 9.2.23 which is many versions behind upstream. I wonder what will happen when major version upgrade is released on CentOS and I run yum update as usual. Will it render my database in unusable state? If so, what is the best approach to prevent it from happening?

4

I wonder what will happen when major version upgrade is released on CentOS

This will not happen. One of the core principles of RHEL/CentOS is that packages never get a major version upgrade, or an upgrade which would result in breaking changes (or that's the intent, as occasionally a breaking change might make its way in).

If you want to upgrade PostgreSQL, use the official PostgreSQL Yum repos. These packages install their files in a separate location, to where you could run multiple different versions simultaneously on the same server if you so desired.

|improve this answer|||||

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.