Fwd: Postgresql 12.19 compatible with RHEL 9

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