using below commands. As 14.6 is already there, would I able to be install 14.9 separately?
I want to upgrade from 14.6 to 14.9
Below commands picks 14.9 default as latest during installation
-----------------
# Install the repository RPM:
sudo yum install -y https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm
# Install PostgreSQL:
sudo yum install -y postgresql14-server
# Optionally initialize the database and enable automatic start:
sudo /usr/pgsql-14/bin/postgresql-14-setup initdb
sudo systemctl enable postgresql-14
sudo systemctl start postgresql-14
-------------------------------
All information about minor version updates are here: https://www.postgresql.org/support/versioning/
Thanks, I appreciate! So can I follow to update version from 14.6 to 14.9 ? 1) Shutdown the old cluster 14.6 2)mv /usr/local/pgsql /usr/local/pgsql.old 3)Install new binaries 14.9 4)/usr/pgsql-14/bin/postgresql-14-setup initdb 5)systemctl start postgresql-14 6)systemctl enable postgresql-14 7)Restore cluster backup and wal files
Follow the guidelines on https://www.postgresql.org/support/versioning/ And read the release notes as for example 14.10 does require a reindex. And why on earth not the latest 14 minor version???
Ok, but can i follow process which i have mentioned as it comfortable for me
You don't know what you are doing, been pointed to the official documentation which explicitly tells you to follow the documentation and you still ask me, if to check your way of not knowing what to do? That's hilarious.
I am referring to below point - 19.6.1. Upgrading Data via pg_dumpall https://www.postgresql.org/docs/current/upgrading.html
I mean as I have cluster backup of 14.6 of the same server, I wish to restore the same on the same server by installing fresh 14.9
sorry for the trouble. So for upgrading minor version I just have to stop old server, install new binaries and restarting sever right? I referred 14.9 release note, as I have 14.6 to be upgraded 14.9, I did not see any specific manual effort apart from BRIN indexes Correct me if I am wrong.
Обсуждают сегодня