Обсуждение: [MASSMAIL]upgrade from centos 6.8 to 6.10
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
--
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.)
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
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.
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.
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 regardsRon 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.--
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