Opened 10 years ago

Closed 6 years ago

#2960 closed defect (fixed)

Note in soft upgrade docs that legacy.sql needs to be rerun for each minor upgrade

Reported by: robe Owned by: robe
Priority: low Milestone: PostGIS 2.4.4
Component: documentation Version: 2.1.x
Keywords: Cc:

Description (last modified by robe)

As noted by someone on IRC, if you upgrade PostGIS from 2.something to 2.1 and forget to rerun the legacy.sql script (only applies if you ran it in first place),

You may get:

Thing is, spatial queries still report this:

ERROR: could not access file "$libdir/postgis-2.0": No such file or directory

I've also seen the dreaded backend error caused by two versions of PostGIS running in same db with same set of GUCs fighting for each other. The other error (can't remember what it is), happens if postgis-2.0 is still present (then you have the unpleasant situation of 2 instances of PostGIS running)

I'm hoping in 2.2 that we can get rid of all references to $libdir in the legacy scripts, but fair there may be a couple we can't get rid of.

Change History (14)

comment:1 by robe, 10 years ago

Description: modified (diff)

comment:2 by robe, 10 years ago

Description: modified (diff)

comment:3 by pramsey, 9 years ago

Milestone: PostGIS 2.1.5PostGIS 2.1.6

comment:4 by pramsey, 9 years ago

Milestone: PostGIS 2.1.6PostGIS 2.1.7

comment:5 by robe, 9 years ago

Milestone: PostGIS 2.1.7PostGIS 2.1.8
Priority: mediumlow

comment:6 by robe, 9 years ago

Milestone: PostGIS 2.1.8PostGIS 2.2.0

comment:7 by robe, 9 years ago

Milestone: PostGIS 2.2.0PostGIS 2.1.9

this is really something that should be backported once fixed, but too lazy to do for 2.2

comment:8 by pramsey, 7 years ago

Milestone: PostGIS 2.1.9PostGIS 2.2.6

comment:9 by robe, 7 years ago

Milestone: PostGIS 2.2.6PostGIS 2.4.1

comment:10 by pramsey, 7 years ago

Milestone: PostGIS 2.4.1PostGIS 2.4.2

comment:11 by pramsey, 6 years ago

Milestone: PostGIS 2.4.2PostGIS 2.4.3

comment:12 by robe, 6 years ago

Milestone: PostGIS 2.4.3PostGIS 2.4.4

comment:13 by robe, 6 years ago

In 16494:

note in docs about soft upgrade that legacy.sql must be rerun for each minor.
References #2960 for PostGIS 2.5.0 (trunk)

comment:14 by robe, 6 years ago

Resolution: fixed
Status: newclosed

In 16495:

note in docs about soft upgrade that legacy.sql must be rerun for each minor.
Closes #2960 for PostGIS 2.4.4

Note: See TracTickets for help on using tickets.