Re: Postgresql 12.19 compatible with RHEL 9

Dear wasim,

If this is test then do thorough testing. Also, if you want to run
temporarily then why not retains same OS and PG release? If query is
behaving differently take an explain plan for it and check the cost of the
query. Also, try to re-create indexes for that query table and analyze the
table as well. Check the compatibility matrix for PG and RHEL releases.

Thanks,
Imran

On Fri, Jun 28, 2024, 1:00 PM Wasim Devale <wasimd60(at)gmail(dot)com> wrote:

> 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/
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>