Обсуждение: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?
Dear Postgresql community:
We are very new users of the Postgresql databases!
We have noticed that there is a separate Postgres installation files for different version of the same O/S such as Redhat Linux (one Postgres install file for RHEL 6, one Postgres intall file for RHEL 7, one Postgres install file for RHEL 8, etc.)
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??
Thank you very much,
-Peter
Peter Lee <peterlee3672@yahoo.com> writes: > Question: will Postgres databases (such as Postgres12 originally installed on a RHEL 6 server) continue to function properlyafter 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
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
> 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