Обсуждение: Query related to Linux Upgrade

. If not, can you please share with us a common Postgres version which is compatible with both RHEL6 & RHEL7 environments?

Any help on this is highly appreciated.

Bireshwar Das <das.bireshwar@gmail.com> writes:
> We are now working with Postgres (PostgreSQL) 9.3.14 in the RedHat Linux 6
> environment.Now we have an upgrade planned for the Linux environment to
> RHEL7. So I wanted to know whether current Postgres (PostgreSQL) 9.3.14 is
> compatible with RHEL7 also. If not, can you please share with us a common
> Postgres version which is compatible with both RHEL6 & RHEL7 environments?

9.3.14 is not "current".  The last minor release in the 9.3 branch was
9.3.25.  More to the point, the 9.3 branch has been out of support for
nearly 3 years.  You are upgrading your OS because it is out of support;
you need to do the same for your database.

I concur with David's nearby suggestion that the PG v12 branch might be
a suitable migration target for you.  12.7 is current, although 12.8
is due out next week.

            regards, tom lane

How do I unsubscribe?

-----Original Message-----
From: Tom Lane <tgl@sss.pgh.pa.us> 
Sent: Friday, August 6, 2021 9:42 AM
To: Bireshwar Das <das.bireshwar@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: [Non-DoD Source] Re: Query related to Linux Upgrade

Bireshwar Das <das.bireshwar@gmail.com> writes:
> We are now working with Postgres (PostgreSQL) 9.3.14 in the RedHat 
> Linux 6 environment.Now we have an upgrade planned for the Linux 
> environment to RHEL7. So I wanted to know whether current Postgres 
> (PostgreSQL) 9.3.14 is compatible with RHEL7 also. If not, can you 
> please share with us a common Postgres version which is compatible with
both RHEL6 & RHEL7 environments?

9.3.14 is not "current".  The last minor release in the 9.3 branch was
9.3.25.  More to the point, the 9.3 branch has been out of support for
nearly 3 years.  You are upgrading your OS because it is out of support; you
need to do the same for your database.

I concur with David's nearby suggestion that the PG v12 branch might be a
suitable migration target for you.  12.7 is current, although 12.8 is due
out next week.

            regards, tom lane