Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database - Mailing list pgsql-admin

From Pepe TD Vo
Subject Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
Date
Msg-id B17C6F7A-88DE-431A-BB99-E48B855E2BC4@yahoo.com
Whole thread Raw
In response to Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database  (Imran Khan <imran.k.23@gmail.com>)
List pgsql-admin
When I built a new server last week and found there are rh-posgresql version 9 - 12 on it, not postgresql (without rh-).  Maybe you need to download and yum install the new version.  If you already yum postgresql-13 on the server before OS upgrade, it should be there. 
Do yum search posgresql and make sure the version you are looking are existed


Sent from my iPad

On Mar 19, 2021, at 3:25 AM, Imran Khan <imran.k.23@gmail.com> wrote:


Best is to get a parallel server and setup postgresql12 and perform export from rhel6 pg instance and import into rhel7 pg instance ..

Thanks,
Imran

On Fri, 19 Mar 2021, 10:12 ram pratap maurya, <rampratap0000@gmail.com> wrote:

Dear Team,

 

we are planing to RHEL OS upgrade from 6.7 (Current version)  to 8 version.

currently postgresql-12.6 version running on the server ,  we have upgraded OS on test DB server from 6 to 8 version  during  OS upgrade postgresql-12,11 and other package is removed  and Postgresql is not started. that why my DB is crashed , can you please suggest what is best way to upgrade OS.

 

And also confirm postgresql-13 support RHEL 6 version because during installation its showing postgresql13-server  not found.

 

.....................................

 

# rpm iav | grep 'el6'

atop-1.27-2.el6.x86_64                                      Fri Jul 13 12:35:22 2018

bakefile-0.2.8-3.el6.centos.x86_64                          Fri May 20 15:40:05 2016

glances-1.7.4-1.el6.noarch                                  Fri Jul 13 12:44:57 2018

htop-1.0.3-1.el6.x86_64                                     Fri Jul 13 12:34:03 2018

iftop-1.0-0.14.pre4.el6.x86_64                              Fri Jul 13 12:40:07 2018

nethogs-0.8.5-1.el6.x86_64                                  Fri Jul 13 12:36:37 2018

nmon-16g-3.el6.x86_64                                       Fri Jul 13 12:43:13 2018

postgresql11-11.11-2PGDG.rhel6.x86_64                       Thu Mar 11 19:17:57 2021

postgresql11-contrib-11.11-2PGDG.rhel6.x86_64               Thu Mar 11 19:18:30 2021

postgresql11-libs-11.11-2PGDG.rhel6.x86_64                  Thu Mar 11 19:17:27 2021

postgresql11-server-11.11-2PGDG.rhel6.x86_64                Thu Mar 11 19:17:58 2021

postgresql12-12.6-2PGDG.rhel6.x86_64                        Thu Mar 11 19:17:56 2021

postgresql12-contrib-12.6-2PGDG.rhel6.x86_64                Thu Mar 11 19:18:30 2021

postgresql12-libs-12.6-2PGDG.rhel6.x86_64                   Thu Mar 11 19:17:26 2021

postgresql12-server-12.6-2PGDG.rhel6.x86_64                 Thu Mar 11 19:18:00 2021

postgresql94-9.4.8-1PGDG.rhel6.x86_64                       Mon May 23 23:14:42 2016

postgresql94-contrib-9.4.8-1PGDG.rhel6.x86_64               Mon May 23 23:14:42 2016

postgresql94-devel-9.4.8-1PGDG.rhel6.x86_64                 Tue May 24 01:06:53 2016

postgresql94-libs-9.4.8-1PGDG.rhel6.x86_64                  Mon May 23 23:14:41 2016

postgresql94-server-9.4.8-1PGDG.rhel6.x86_64                Mon May 23 23:14:43 2016

postgresql96-9.6.21-1PGDG.rhel6.x86_64                      Thu Mar 11 19:17:55 2021

postgresql96-contrib-9.6.21-1PGDG.rhel6.x86_64              Thu Mar 11 19:18:29 2021

postgresql96-devel-9.6.21-1PGDG.rhel6.x86_64                Thu Mar 11 19:18:31 2021

postgresql96-docs-9.6.21-1PGDG.rhel6.x86_64                 Thu Mar 11 19:19:24 2021

postgresql96-libs-9.6.21-1PGDG.rhel6.x86_64                 Thu Mar 11 19:17:26 2021

postgresql96-server-9.6.21-1PGDG.rhel6.x86_64               Thu Mar 11 19:18:01 2021

python-empy-3.3-5.el6.centos.noarch                         Fri May 20 15:40:05 2016

python-psutil-0.6.1-1.el6.x86_64                            Fri Jul 13 12:44:56 2018

ql2400-firmware-7.03.00-1.el6_5.noarch                      Tue May 10 18:39:39 2016

ql2500-firmware-7.03.00-1.el6_5.noarch                      Tue May 10 18:39:39 2016

wxBase-2.8.12-1.el6.centos.x86_64                           Fri May 20 15:39:57 2016

wxGTK-2.8.12-1.el6.centos.x86_64                            Fri May 20 15:39:58 2016

wxGTK-devel-2.8.12-1.el6.centos.x86_64                      Fri May 20 15:40:06 2016

wxGTK-gl-2.8.12-1.el6.centos.x86_64                         Fri May 20 15:39:59 2016

wxGTK-media-2.8.12-1.el6.centos.x86_64                      Fri May 20 15:39:59 2016

pgsql-admin by date:

Previous
From: Imran Khan
Date:
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
Next
From: Holger Jakobs
Date:
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database