From: Tom Lane <tgl@sss.pgh.pa.us>
To: ram pratap maurya <rampratap0000@gmail.com>
Cc: paul.foerster@gmail.com
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: RHEL OS upgrade from 6.7 (Current version) to 8 version for Postgresql database
Date: Fri, 19 Mar 2021 10:19:57 -0400
Message-ID: <4058401.1616163597@sss.pgh.pa.us> (raw)
In-Reply-To: <CAAiDzSfzh2Ms-GYqbHfPcWGdfGEJT8ObQQp+rvYPS7+82HB+uw@mail.gmail.com>
References: <CAAiDzSfzh2Ms-GYqbHfPcWGdfGEJT8ObQQp+rvYPS7+82HB+uw@mail.gmail.com>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: tgl@sss.pgh.pa.us, rampratap0000@gmail.com, 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
In-Reply-To: <4058401.1616163597@sss.pgh.pa.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox