pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: MichaelDBA <MichaelDBA@sqlexec.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: 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 13:18:17 -0400
Message-ID: <199c5a46-8866-7286-f368-45f0c1665091@sqlexec.com> (raw)
In-Reply-To: <4058401.1616163597@sss.pgh.pa.us>
References: <CAAiDzSfzh2Ms-GYqbHfPcWGdfGEJT8ObQQp+rvYPS7+82HB+uw@mail.gmail.com>
	<4058401.1616163597@sss.pgh.pa.us>

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






view thread (9+ messages)  latest in thread

Message-ID: <199c5a46-8866-7286-f368-45f0c1665091@sqlexec.com>
Permalink:  ../199c5a46-8866-7286-f368-45f0c1665091@sqlexec.com/
Also on:    postgresql.org/message-id/199c5a46-8866-7286-f368-45f0c1665091@sqlexec.com

 · 

reply
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: MichaelDBA@sqlexec.com, 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: <199c5a46-8866-7286-f368-45f0c1665091@sqlexec.com>

* 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