I have 14.6 installed, how to install 14.9. I am

Question

I have 14.6 installed, how to install 14.9. I am

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
-------------------------------

#programming #russian

0

10.11.2023

8 ответов

42 просмотра

SP Автор вопроса

Stefanie Janine Stölting
All information about minor version updates are he...

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

0

14.11.2023

Stefanie Janine Stölting

SP
Thanks, I appreciate! So can I follow to update v...

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???

0

14.11.2023

SP Автор вопроса

Stefanie Janine Stölting
Follow the guidelines on https://www.postgresql.or...

Ok, but can i follow process which i have mentioned as it comfortable for me

0

14.11.2023

Stefanie Janine Stölting

SP
Ok, but can i follow process which i have mentione...

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.

0

14.11.2023

SP Автор вопроса

Stefanie Janine Stölting
You don't know what you are doing, been pointed to...

I am referring to below point - 19.6.1. Upgrading Data via pg_dumpall https://www.postgresql.org/docs/current/upgrading.html

0

14.11.2023

SP Автор вопроса

SP
I am referring to below point - 19.6.1. Upgrading ...

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

0

14.11.2023

SP Автор вопроса

Stefanie Janine Stölting
You don't know what you are doing, been pointed to...

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.

0

14.11.2023

Stefanie Janine Stölting · Accepted Answer

Stefanie Janine Stölting

All information about minor version updates are here: https://www.postgresql.org/support/versioning/

0

10.11.2023

169 похожих чатов

I have 14.6 installed, how to install 14.9. I am

8 ответов

Похожие вопросы