Change Debbie to also test extension upgrade

[robe]

Right now none of the bots test the extension upgrade feature strk put in. Going to change that so we have better regression testing and hopefully fewer surprises when we release.

Won't be able to make this change until fix at least issue #2673

[robe]

I think I figured out the problem here. It's that liblwgeom that want's to install itself in /usr/local/lib and since I'm running jenkins under an unprivileged account, it can't install there. Do we have a way to compile that statically into postgis.so file. I'd rather not have that file installed in some place since it also makes our tests dependent on one another in unpredictable ways (micros).

In windows it just naturally ends up being statically compiled though it still tries to install include files which is very annoying.

[strk]

I've added upgrade testing to Dronie, using the new utils/check_all_upgrades.sh — you may find that script useful for Debbie and Winnie. For liblwgeom install path (which may affect loader/dumper) you may try using —prefix

[strk]

See #635 if —prefix doesn't work

[strk]

I've added upgrade testing to Debbie, using utils/check_all_upgrades.sh in ci/debbie/postgis_regress.sh of trunk branch with r16226 - let's see if it works and it can be improved by installing more versions of PostGIS on the machine.

[strk]

unpackaged—2.5.0dev extension upgrade fails with:

ERROR: extension "postgis_sfcgal" does not exist

See ​https://debbie.postgis.net/job/PostGIS_Regress/8259/console

Regina: ideas ?

[strk]

It looks like I fixed the "postgis_sfcgal" issue as of r16340 I'm closing this. Reopen if you you see failures related to upgrade testing.

[strk]

In 16346:

Have Debbie test all available upgrades

References #2676 for 2.4 branch

[strk]

I'm reopening to backport the testing to older branches.

[strk]

Although now Debbie also tests upgrades in the 2.4 branch there's effectively no upgrade test being run, probably because there's no system-wide installed PostGIS < 2.4.3 - do you confirm Regina ? See ​https://debbie.postgis.net/job/PostGIS_Regress/8472/console

[robe]

Milestone renamed

[strk]

Debbie is definitely testing upgrades now, as shown by the (failing) upgrade test in ​https://debbie.postgis.net/job/PostGIS_Regress/25034/

I think the failure at hand was due to not using postgis minor library version when installing, and builds upgrading from installs of other builds. Everything pretty unstable if you ask me, but somehow these permutations might be also good testing.

HOpefully [76505b970ea1c91bdde2870652c4415ab359083e/git] fixed the failure but the focus of THIS ticket was to request Debbie testing of upgrades and so I'm closing it as done.