Re: Postgresql 12.19 compatible with RHEL 9

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