FS#68921 - PostGIS built for PostgreSQL 12.0 cannot be loaded in PostgreSQL 13.1

Attached to Project: Community Packages
Opened by Kassian Sun (Ksmata) - Thursday, 10 December 2020, 12:12 GMT
Last edited by Jaroslav Lichtblau (Dragonlord) - Saturday, 26 December 2020, 10:04 GMT
Task Type Bug Report
Category Packages
Status Closed
Assigned To Jaroslav Lichtblau (Dragonlord)
Architecture All
Severity Medium
Priority Normal
Reported Version
Due in Version Undecided
Due Date Undecided
Percent Complete 100%
Votes 7
Private No

Details

Description:
The current postgis package needs to be rebuilt with postgresql==13.1 to make it work

Additional info:
* package version(s)
* config and/or log files etc.
* link to upstream bug report, if any

Steps to reproduce:
1. Upgrade postgresql
2. Try to install postgis extension
This task depends upon

Closed by  Jaroslav Lichtblau (Dragonlord)
Saturday, 26 December 2020, 10:04 GMT
Reason for closing:  Implemented
Additional comments about closing:  postgis 3.0.3-1 in community rebuilt against latest postgresql
Comment by Ben Davis (bendavis78) - Monday, 21 December 2020, 16:21 GMT
I am also having this issue. Is there a workaround? I'm currently unable to get my database working locally.

$ psql template1
psql (13.1)
Type "help" for help.

template1=# CREATE EXTENSION postgis;
ERROR: PostGIS built for PostgreSQL 12.0 cannot be loaded in PostgreSQL 13.1
CONTEXT: PL/pgSQL function inline_code_block line 15 at RAISE
template1=#
Comment by Stephane Goldstein (skualos) - Tuesday, 22 December 2020, 00:48 GMT
I edited the PKGBUILD file to version 3.0.3, then installed it with makepkg -si

https://github.com/archlinux/svntogit-community/blob/packages/postgis/trunk/PKGBUILD

Loading...