Thread: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
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
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
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
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
On Mar 19, 2021, at 3:25 AM, Imran Khan <imran.k.23@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
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
A bit off-topic, but CentOS 7 gets far longer support than CentOS 8. CentOS 8 is only supported until the end of this year. See https://www.centos.org/centos-linux/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.
-- Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012
Attachment
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
ram pratap maurya <rampratap0000@gmail.com> writes: > 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. There are a couple of big gotchas you need to think about: * RHEL8 is systemd based, while 6 still used the old initscript startup code. This means that the way to get a daemon process launched is completely different. So PG packages built for RHEL6 *will not work*. You need to get a server package that is systemd-ready, and that means one that was explicitly built for RHEL8. (Maybe a RHEL7 one would work, not sure. But it is zero surprise that the packages you listed aren't working.) * RHEL8 incorporates new locale data [1]. This means that non-English text is rather likely to sort differently than it did before, which in turn means that indexes on text columns will be corrupt if you try to upgrade in place. While you could REINDEX them after updating, this might be a good reason to do a dump-and-reload instead of trying to pg_upgrade. In short, this is no minor upgrade you're contemplating. regards, tom lane [1] https://wiki.postgresql.org/wiki/Locale_data_changes
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
> On Mar 19, 2021, at 8:19 AM, Tom Lane <tgl@sss.pgh.pa.us> wrote: > > RHEL8 incorporates new locale data [1]. This means that non-English > text is rather likely to sort differently than it did before I *think* I saw that random uuid-style strings of alphanumerics and underscores or dashes also sorted differently. I didn'tstop to take time to definitively verify that, but just kept on with re-indexing as quickly as possible. But I definitelysaw symptoms of corrupted indexes until the reindex completed, and they appeared with the OS upgrade, not before,*as far as I know*
Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
On a side note, shouldn't you be upgrading to CentOS Stream instead of CentOS 8? Tom Lane wrote on 3/19/2021 10:19 AM: > ram pratap maurya <rampratap0000@gmail.com> writes: >> 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. > There are a couple of big gotchas you need to think about: > > * RHEL8 is systemd based, while 6 still used the old initscript startup > code. This means that the way to get a daemon process launched is > completely different. So PG packages built for RHEL6 *will not work*. > You need to get a server package that is systemd-ready, and that means > one that was explicitly built for RHEL8. (Maybe a RHEL7 one would > work, not sure. But it is zero surprise that the packages you listed > aren't working.) > > * RHEL8 incorporates new locale data [1]. This means that non-English > text is rather likely to sort differently than it did before, which in > turn means that indexes on text columns will be corrupt if you try to > upgrade in place. While you could REINDEX them after updating, this > might be a good reason to do a dump-and-reload instead of trying to > pg_upgrade. > > In short, this is no minor upgrade you're contemplating. > > regards, tom lane > > [1] https://wiki.postgresql.org/wiki/Locale_data_changes > >
RE: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
This is the first I have heard about Centos Stream. I found an announcement dated 8 December 2020 saying that CentOS Projectis shifting focus to CentOS Stream, and a LOT of comments and confusion. The main thing is that Stream apparently tracks Ahead of a current RHEL release. This may be a concern because I and many others use CentOS as a stable 'tried and tested' platform not a 'cutting edge' platform. Of course, I may be just as confused as everyone else seems to be about what all this actually means. Getting a bit off topic here, so apologies if I'm upsetting anyone. Regards, Dave Bolt -----Original Message (extract) ----- From: MichaelDBA [mailto:MichaelDBA@sqlexec.com] Sent: 19 March 2021 17:18 To: Tom Lane Cc: ram pratap maurya; paul.foerster@gmail.com; pgsql-admin@lists.postgresql.org Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database On a side note, shouldn't you be upgrading to CentOS Stream instead of CentOS 8?
RH heard the wails of complaint; their solution is to license RHEL for free up on up to 16 servers per customer. At least that's what Ars Technica says. https://arstechnica.com/gadgets/2021/01/centos-is-gone-but-rhel-is-now-free-for-up-to-16-production-servers/ On 3/19/21 2:42 PM, Dave Bolt wrote: > This is the first I have heard about Centos Stream. I found an announcement dated 8 December 2020 saying that CentOS Projectis shifting focus to CentOS Stream, and a LOT of comments and confusion. > The main thing is that Stream apparently tracks Ahead of a current RHEL release. > This may be a concern because I and many others use CentOS as a stable 'tried and tested' platform not a 'cutting edge'platform. > > Of course, I may be just as confused as everyone else seems to be about what all this actually means. > > Getting a bit off topic here, so apologies if I'm upsetting anyone. > > Regards, > Dave Bolt > > -----Original Message (extract) ----- > From: MichaelDBA [mailto:MichaelDBA@sqlexec.com] > Sent: 19 March 2021 17:18 > To: Tom Lane > Cc: ram pratap maurya; paul.foerster@gmail.com; pgsql-admin@lists.postgresql.org > Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database > > On a side note, shouldn't you be upgrading to CentOS Stream instead of > CentOS 8? -- Angular momentum makes the world go 'round.