PostgreSQL Minor version upgrade

Here I am going to upgrade minor version of PostgreSQL12. In my example Database is PostgreSQL12.7 and OS is Centos7. Now, I am going to upgrade it on PostgreSQL12.8. 

 Step 1. Before upgrading or doing anything on any server please take a backup of your entire database through pg_dump or pg_basebackup or through any other tools. 

Step 2. To see your current version of PostgreSQL Database 

[root@test /]#su postgres 

bash-4.2$plsql 

postgres=#select version(); 

output : 

 version

 ---------------------------------------------------------- 

PostgreSQL 12.7 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit 

(1 row) 

Now exit from PostgreSQL.

postgres=#\q 

bash-4.2$exit 

Step 3. Stop PostgreSQL server 

[root@test /]#systemctl status postgresql-12.service 

[root@test /]#systemctl stop postgresql-12.service 

Step 4. Download latest rpm of PostgreSQL12 

[root@test /]#yum -y install https://download.postgresql.org/pub/repos/yum/reporpms/EL-7-x86_64/pgdg-redhat-repo-latest.noarch.rpm 

[root@test /]#yum install postgresql12-server 

Now your server has been upgraded by new minor version. You can check it with below commands.

root@test /]#su postgres 

bash-4.2$plsql 

postgres=# select version(); 

output : 

version 

---------------------------------------------------------- 

PostgreSQL 12.8 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-44), 64-bit