Bug 29196

Summary:	Impossible to create postgis extention on a PostgreSQL database
Product:	Mageia	Reporter:	Maat <maat-ml>
Component:	RPM Packages	Assignee:	Nicolas Lécureuil <mageia>
Status:	NEW ---	QA Contact:
Severity:	major
Priority:	Normal	CC:	maat-ml
Version:	8
Target Milestone:	---
Hardware:	All
OS:	Linux
Whiteboard:
Source RPM:	postgis-3.0.2-2.mga8.src.rpm	CVE:
Status comment:

Description Maat 2021-07-01 09:42:17 CEST

Description of problem:

In short there is something that blocks the activation of the Postgis Extension on a databse which is a complete blocker for using geo-enabled databases


Version-Release number of selected component (if applicable):

See src.rpm field

How reproducible:

Always

Steps to Reproduce:
1. As root : # urpmi postgis
2. As root : # systemctl start postgresql
3. As root : # su - postgres
4. As postgres : $ createdb  test
5. As postgres : psql test
6. As postgres (in psql) : CREATE EXTENSION postgis;


Result : ERROR:  syntax error at or near "SUPPORT"
Expected result : should succeed instead of displaying an error message.

Comment 1 Lewis Smith 2021-07-01 21:48:21 CEST

Thank you for the report (which I have not tried to re-create).

This SRPM has no registered maintainer, but DavidG has done all recent updates, so assigning to you.
I wonder whether enquiring on the dev ML would help.

Assignee: bugsquad => geiger.david68210

Comment 2 Maat 2021-07-02 08:06:06 CEST

I tried to rebuild postgis rpm (the last version from mgarepo) : same result.

It might be on PostreSQL side rather than on Postgis itself.

But at the moment our Mga 8 it totally unable to host a postgres database with geo-localization objects inside.

I did set the severity to major but for people who use geometry fields in their application its a complete deal breaker.

Best regards,
Maât

Maat 2021-07-02 08:06:41 CEST

CC: (none) => maat-ml

Comment 3 Maat 2021-07-07 11:23:50 CEST

Hello,

Here is a src.rpm postgis2 version forward-ported from the mga7 version:

https://mageia.biz/repo/Mageia/distrib/8/SRPMS/postgres/postgis2-2.5.2-1.mga8.src.rpm

I renamed is postgis2 so that the mga8 version does not compete with it.

Note : It's built against posgresql11 instead of postgressql13

I could create the extension postgis on my test database and, more, i imported a production version of my "real" database with pg_restore and could start and use the application without problem.

So this src.rpm does definitely works with mga8 (and with pg11) on the contrary of the current mga8 version.

I suggest that we provide a postgis2 with postgresql11 and a (fixed) postgis3 with postgresql13 so that people can use at their option pg11 or pg13

Kind regards,
Maât

Maat 2021-07-07 11:24:45 CEST

Assignee: geiger.david68210 => mageia