Обсуждение: [MASSMAIL]upgrade from centos 6.8 to 6.10

Поиск
Список
Период
Сортировка

[MASSMAIL]upgrade from centos 6.8 to 6.10

От
Muhammet Kurtoğlu
Дата:
Hi we want to upgrade from centos 6.8 to 6.10.
We have postgresql 9.4 with postgis .
in new patch will postgresql 9.4 can work without problem.
Best regards

--

Re: upgrade from centos 6.8 to 6.10

От
Ron Johnson
Дата:

On Wed, Mar 27, 2024 at 9:23 AM Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr> wrote:
Hi we want to upgrade from centos 6.8 to 6.10.
We have postgresql 9.4 with postgis .
in new patch will postgresql 9.4 can work without problem.

I presume this is a question.  Yes, it'll work just fine.

(You of course know that CENTOS 6 and PG 9.4 are far beyond EOL, and should be upgraded immediately to Rocky 9 and PG 15 or 16, so I won't mention it.)

Re: upgrade from centos 6.8 to 6.10

От
Laurenz Albe
Дата:
On Wed, 2024-03-27 at 16:23 +0300, Muhammet Kurtoğlu wrote:
> Hi we want to upgrade from centos 6.8 to 6.10.
> We have postgresql 9.4 with postgis .
> in new patch will postgresql 9.4 can work without problem.

If you rebuild all the indexes on string expressions, it may work.

But certainly not without a problem.  The versions alone are a problem.

Yours,
Laurenz Albe



Re: upgrade from centos 6.8 to 6.10

От
Ron Johnson
Дата:
On Thu, Mar 28, 2024 at 5:21 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2024-03-27 at 16:23 +0300, Muhammet Kurtoğlu wrote:
> Hi we want to upgrade from centos 6.8 to 6.10.
> We have postgresql 9.4 with postgis .
> in new patch will postgresql 9.4 can work without problem.

If you rebuild all the indexes on string expressions, it may work.

Why?  It's not like a point release changes glibc's major (or even minor) version.

Re: upgrade from centos 6.8 to 6.10

От
Muhammet Kurtoğlu
Дата:

Sorry,
We are upgrading from centos 6.2 to 6.10.
Is it necessary yo rebuild all the indexes on string expressions ?
bet regards

Ron Johnson <ronljohnsonjr@gmail.com>, 28 Mar 2024 Per, 16:06 tarihinde şunu yazdı:
On Thu, Mar 28, 2024 at 5:21 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2024-03-27 at 16:23 +0300, Muhammet Kurtoğlu wrote:
> Hi we want to upgrade from centos 6.8 to 6.10.
> We have postgresql 9.4 with postgis .
> in new patch will postgresql 9.4 can work without problem.

If you rebuild all the indexes on string expressions, it may work.

Why?  It's not like a point release changes glibc's major (or even minor) version.



--

Re: upgrade from centos 6.8 to 6.10

От
Ron Johnson
Дата:
6.10 uses glibc 2.12.1.212.el6_10.3.  The "2.12" is what matters.  If 6.2 also runs "2.12" then there is no need to rebuild indices with text columns.

On Thu, Mar 28, 2024 at 9:09 AM Muhammet Kurtoğlu <muhammet.kurtoglu@bisoft.com.tr> wrote:

Sorry,
We are upgrading from centos 6.2 to 6.10.
Is it necessary yo rebuild all the indexes on string expressions ?
bet regards

Ron Johnson <ronljohnsonjr@gmail.com>, 28 Mar 2024 Per, 16:06 tarihinde şunu yazdı:
On Thu, Mar 28, 2024 at 5:21 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
On Wed, 2024-03-27 at 16:23 +0300, Muhammet Kurtoğlu wrote:
> Hi we want to upgrade from centos 6.8 to 6.10.
> We have postgresql 9.4 with postgis .
> in new patch will postgresql 9.4 can work without problem.

If you rebuild all the indexes on string expressions, it may work.

Why?  It's not like a point release changes glibc's major (or even minor) version.



--

Re: upgrade from centos 6.8 to 6.10

От
Laurenz Albe
Дата:
On Thu, 2024-03-28 at 09:05 -0400, Ron Johnson wrote:
> On Thu, Mar 28, 2024 at 5:21 AM Laurenz Albe <laurenz.albe@cybertec.at> wrote:
> > On Wed, 2024-03-27 at 16:23 +0300, Muhammet Kurtoğlu wrote:
> > > Hi we want to upgrade from centos 6.8 to 6.10.
> > > We have postgresql 9.4 with postgis .
> > > in new patch will postgresql 9.4 can work without problem.
> >
> > If you rebuild all the indexes on string expressions, it may work.
>
> Why?  It's not like a point release changes glibc's major (or even minor) version.

You are right, then there should not be any problem with changing collations.

Yours,
Laurenz Albe