Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7? - Mailing list pgsql-hackers

From Peter Lee
Subject Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?
Date
Msg-id 817834164.1151365.1620516933143@mail.yahoo.com
Whole thread Raw
In response to Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hi Tom,

Yes, I totally agree with you that the OS upgrade should take place first before we install Postgres.

It is just that Postgres was already installed on a RHEL6 server before my time.  

What preparations do you recommend us to do minimize the possible hazard after the OS upgrade?

Thank you very much in advance,

-Peter



在 2021年5月8日 星期六 下午12:52:29 [PDT], Tom Lane<tgl@sss.pgh.pa.us> 寫道:


Peter Lee <peterlee3672@yahoo.com> writes:

> Question:  will Postgres databases (such as Postgres12 originally installed on a RHEL 6 server) continue to function properly after the server get O/S upgrade to RHEL 7??


Possibly, but why don't you do the OS upgrade first?  RHEL6 has been
EOL for some time, so installing new functionality on a server that's
still running that doesn't seem like prudent sysadmin-ship.

The main hazard you'd be looking at if you do it in the other order
is that RHEL7 might have different locale sorting behavior, resulting
in effectively-corrupt indexes on text columns.  For more info about
that see

https://wiki.postgresql.org/wiki/Locale_data_changes

That page claims that only the de_DE.UTF-8 locale changed in RHEL7,
but I don't know that I'd risk money on that being true.

            regards, tom lane

pgsql-hackers by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: 2021-05-13 release announcement draft
Next
From: David Rowley
Date:
Subject: Re: plan with result cache is very slow when work_mem is not enough