Skip to main content

Posts

Showing posts from August, 2021

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