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

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?
Дата
Msg-id 292598.1620503546@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?  (Peter Lee <peterlee3672@yahoo.com>)
Ответы Re: Will Postgres12 installed on a RHEL 6 server continue to function after the server get O/S upgrade to RHEL 7?  (Peter Lee <peterlee3672@yahoo.com>)
Список pgsql-hackers
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



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Reducing opr_sanity test's runtime under CLOBBER_CACHE_ALWAYS
Следующее
От: "Jonathan S. Katz"
Дата:
Сообщение: 2021-05-13 release announcement draft