Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database

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(dot)k(dot)23(at)gmail(dot)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(at)gmail(dot)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