[postgis-devel] [postgis-users] PostGIS Known Issues : OEL7 to RHEL8 Upgrade

[Nikhil Shetty]

Hi Regina,

Please let us know if upgrading to RHEL8 with 3.1.2 would be an issue or
any other known issues with PostGIS

Thanks,
Nikhil

On Thu, 24 Aug 2023 at 08:24, Nikhil Shetty <nikhil.dba04 at gmail.com> wrote:

>
> Hi Regina,
>
> We do have plans to upgrade both Postgres and PostGIS to higher versions
> but currently we are focusing on OS upgrade to RHEL8
>
> Do you think being on PostGIS 3.1.2 will impact OS upgrade? Are there any
> known issues
>
> Thanks,
> Nikhil
>
> On Wed, 23 Aug 2023 at 23:41, Regina Obe <lr at pcorp.us> wrote:
>
>> 3.1.2 is not the latest stable release for 3.1, so you really shouldn’t
>> be using that.  The 3.1.2 is before the PostgreSQL security vulnerability
>> patches for example and numerous bugs have been fixed since then.
>>
>>
>>
>> Latest 3.1 is 3.1.9
>>
>>
>>
>>
>> https://postgis.net/2023/05/PostGIS-3.3.3-3.2.5-3.1.9-3.0.9-Patch-Releases/
>>
>> News specific for 3.1 -
>> https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.1.9/NEWS
>>
>>
>>
>> I would say the same holds true for PostgreSQL 13.12 is the latest
>> stable, so not sure why you are trying to use a version several micro
>> updates behind
>>
>>
>>
>>
>> https://www.postgresql.org/about/news/postgresql-154-149-1312-1216-1121-and-postgresql-16-beta-3-released-2689/
>>
>>
>>
>>
>>
>> Hope that helps,
>>
>> Regina
>>
>>
>>
>>
>>
>> *From:* postgis-devel [mailto:postgis-devel-bounces at lists.osgeo.org] *On
>> Behalf Of *Nikhil Shetty
>> *Sent:* Wednesday, August 23, 2023 2:02 PM
>> *To:* PostGIS Development Discussion <postgis-devel at lists.osgeo.org>;
>> postgis-users at lists.osgeo.org
>> *Subject:* [postgis-devel] PostGIS Known Issues : OEL7 to RHEL8 Upgrade
>>
>>
>>
>> Hi Team,
>>
>>
>>
>> We want to know if there are any open/known issues that we may face
>> post-migration of the Postgres database  instance  with PostGIS enabled
>> from centos7/RHEL7/OEL7 to RHEL8.
>>
>>
>>
>> We came across one issue regarding collation(
>> https://wiki.postgresql.org/wiki/Locale_data_changes), the solution for
>> which is to reindex or use logical replication. This is not related to
>> PostGIS but still a concern causing index corruption
>>
>>
>>
>> In a similar way, we want to understand if there are any other known
>> issues related to PostGIS that should be taken care of
>>
>>
>>
>> PostgreSQL : 13.6
>>
>> PostGIS : 3.1.2
>>
>>
>>
>> Thanks and Regards,
>>
>> Nikhil
>> _______________________________________________
>> postgis-users mailing list
>> postgis-users at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/postgis-users
>>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/postgis-devel/attachments/20230825/86e8f606/attachment.htm>