Re: Postgresql 12.19 compatible with RHEL 9

No I checked from developer

On Fri, 28 Jun, 2024, 3:01 pm Imran Khan, <imran(dot)k(dot)23(at)gmail(dot)com> wrote:

> is that query using postgis related type?
>
> On Thu, Jun 27, 2024 at 10:39 PM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:
>
>> Hi All
>>
>> So I used postgresql 13 installed on RHEL 9.
>>
>> It is restored from postgresql 12.8 running on CentOS7.
>>
>> We ran into an issue with only one query that took a long time to run 4
>> hours whereas it was taking 20 mins to run on postgresql 12.8 why this
>> difference other queries are working fine.
>>
>> Note: postgis and pgrouting extension is installed on both.
>>
>> Thanks,
>> Wasim
>>
>> On Thu, 27 Jun, 2024, 9:22 pm Wasim Devale, <wasimd60(at)gmail(dot)com> wrote:
>>
>>> Thanks for the clarification.
>>>
>>> On Wed, 26 Jun, 2024, 6:41 pm Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
>>> wrote:
>>>
>>>> You still haven't read
>>>> https://www.postgresql.org/download/linux/redhat/ and
>>>> https://www.postgresql.org/support/versioning/.
>>>>
>>>> All your questions will be answered if you read them.
>>>>
>>>> On Wed, Jun 26, 2024 at 2:34 AM Wasim Devale <wasimd60(at)gmail(dot)com>
>>>> wrote:
>>>>
>>>>> Thanks I do not have an understanding of the app and Java application
>>>>> which we have and our manager is not comfortable to have this plan you
>>>>> mentioned.
>>>>>
>>>>> Thanks,
>>>>> Wasim
>>>>>
>>>>> On Wed, 26 Jun, 2024, 11:58 am Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
>>>>> wrote:
>>>>>
>>>>>> 1. Did you read the links I sent you? Your question seems to
>>>>>> indicate that you didn't.
>>>>>>
>>>>>> 2. What makes you think that PG16 is sooooooo different from PG 12
>>>>>> that your "old fashioned app" won't run on it? That's just *silly*.
>>>>>>
>>>>>> (We just migrated PG 9.6 databases on RHEL6 to PG 14 on RHEL8. *The
>>>>>> old applications did not change.* Only the JDBC driver needed
>>>>>> updating.)
>>>>>>
>>>>>> On Wed, Jun 26, 2024 at 2:21 AM Wasim Devale <wasimd60(at)gmail(dot)com>
>>>>>> wrote:
>>>>>>
>>>>>>> Thanks
>>>>>>>
>>>>>>> We have an old fashioned app we need to upgrade everything but for a
>>>>>>> time being 1 or 2 months can I use postgresql 12.19 on RHEL 9 so that the
>>>>>>> application's behaviour and old construction SQL queries will match with it
>>>>>>> ?
>>>>>>>
>>>>>>> Thanks,
>>>>>>> Wasim
>>>>>>>
>>>>>>> On Wed, 26 Jun, 2024, 1:23 am Ron Johnson, <ronljohnsonjr(at)gmail(dot)com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> On Tue, Jun 25, 2024 at 3:21 PM Wasim Devale <wasimd60(at)gmail(dot)com>
>>>>>>>> wrote:
>>>>>>>>
>>>>>>>>> Hi All
>>>>>>>>>
>>>>>>>>> Anybody has live experience on installation of postgresql 12.19 on
>>>>>>>>> RHEL 9 server?
>>>>>>>>>
>>>>>>>>
>>>>>>>> Check here: https://www.postgresql.org/download/linux/redhat/
>>>>>>>>
>>>>>>>>
>>>>>>>>> That too running pg for a long term without any issues.
>>>>>>>>>
>>>>>>>>
>>>>>>>> It'll be EOL in five months:
>>>>>>>> https://www.postgresql.org/support/versioning/
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>