Обсуждение: Postgresql 12.19 compatible with RHEL 9

Hi All 

Anybody has live experience on installation of postgresql 12.19 on RHEL 9 server? That too running pg for a long term without any issues.

Thanks,

Wasim

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@gmail.com> wrote:

Thanks for the clarification.

On Wed, 26 Jun, 2024, 6:41 pm Ron Johnson, <ronljohnsonjr@gmail.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@gmail.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@gmail.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@gmail.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@gmail.com> wrote:

On Tue, Jun 25, 2024 at 3:21 PM Wasim Devale <wasimd60@gmail.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/ 

 

is that query using postgis related type? 

On Thu, Jun 27, 2024 at 10:39 PM Wasim Devale <wasimd60@gmail.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@gmail.com> wrote:

Thanks for the clarification.

On Wed, 26 Jun, 2024, 6:41 pm Ron Johnson, <ronljohnsonjr@gmail.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@gmail.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@gmail.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@gmail.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@gmail.com> wrote:

On Tue, Jun 25, 2024 at 3:21 PM Wasim Devale <wasimd60@gmail.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/ 

 

No I checked from developer

On Fri, 28 Jun, 2024, 3:01 pm Imran Khan, <imran.k.23@gmail.com> wrote:

is that query using postgis related type? 

On Thu, Jun 27, 2024 at 10:39 PM Wasim Devale <wasimd60@gmail.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@gmail.com> wrote:

Thanks for the clarification.

On Wed, 26 Jun, 2024, 6:41 pm Ron Johnson, <ronljohnsonjr@gmail.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@gmail.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@gmail.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@gmail.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@gmail.com> wrote:

On Tue, Jun 25, 2024 at 3:21 PM Wasim Devale <wasimd60@gmail.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/