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.
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
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
CC: (none) => maat-ml
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
Assignee: geiger.david68210 => mageia