Opened 9 years ago

Closed 5 years ago

#3273 closed enhancement (fixed)

Have scripts check for PostgreSQL version

Reported by: strk Owned by: strk
Priority: medium Milestone: PostGIS 3.0.0
Component: postgis Version: master
Keywords: Cc:

Description

It happened to me to accidentally load a postgis script into a postgresql version the script was not built for. I did receive an error message but it wasn't clear. I guess you could also not get an error message but end up with an unexpected setup.

This ticket is to add a check in the script to ensure the postgresql version is the one expected by PostGIS at scripts build time.

Change History (3)

comment:1 by robe, 9 years ago

Owner: changed from pramsey to strk

comment:2 by robe, 7 years ago

Milestone: PostGIS FuturePostGIS Fund Me

Milestone renamed

comment:3 by strk, 5 years ago

Milestone: PostGIS Fund MePostGIS 3.0.0
Resolution: fixed
Status: newclosed

This was implemented in r17341

psql:/usr/src/postgis/repository-sync-scripts/postgis/regress/00-regress-install/share/contrib/postgis/postgis.sql:71: ERROR:  PostGIS built for PostgreSQL 10.0 cannot be loaded in PostgreSQL 9.6.9
Note: See TracTickets for help on using tickets.