Setup new bessie on osgeo8

[robe]

I've started setting up a new bessie on osgeo8. I had some obstacles getting the networking to work, so had to add static ip and route.

I'll figure that out later.

But anyway I think I'm about 80% done with her. This new bessie is freebsd 14.1 — used this VM image to setup ​https://download.freebsd.org/ftp/releases/VM-IMAGES/14.1-RELEASE/amd64/Latest/FreeBSD-14.1-RELEASE-amd64-zfs.qcow2.xz

Old bessie is no longer functional, cause she's too old to be able to cleanly install openjdk17 (what is installed on debbie and the berries)

When I'm done with her you should be able to access her via

ssh jenkins@osgeo8-bessie

[robe]

I have all dependencies installed on new bessie but sadly she's failing on regrssion testing

15:21:25 Creating database 'postgis_reg-3.6'.
15:21:25 Loading PostGIS in 'postgis_reg-3.6 using scripts from /home/jenkins/workspace/PostGIS_Worker_Run/label/bessie/e8d47bb440139d9f6c90acfd234e2fe6a668ba3d/regress/00-regress-install/share/contrib/postgis'
15:21:25  failed (Error encountered loading /home/jenkins/workspace/PostGIS_Worker_Run/label/bessie/e8d47bb440139d9f6c90acfd234e2fe6a668ba3d/regress/00-regress-install/share/contrib/postgis/postgis.sql: /home/jenkins/tmp/pgis_reg_e8d47bb440139d9f6c90acfd234e2fe6a668ba3d/regress_log.tmp)
15:21:25 -----------------------------------------------------------------------------
15:21:25 NOTICE:  schema "public" already exists, skipping
15:21:25 psql:/home/jenkins/workspace/PostGIS_Worker_Run/label/bessie/e8d47bb440139d9f6c90acfd234e2fe6a668ba3d/regress/00-regress-install/share/contrib/postgis/postgis.sql:72: ERROR:  could not access file "$libdir/plpgsql": No such file or directory
15:21:25 -----------------------------------------------------------------------------
15:21:25 gmake[1]: *** [regress/runtest.mk:24: check-regress] Error 1
15:21:25 gmake[1]: Leaving directory '/home/jenkins/workspace/PostGIS_Worker_Run/label/bessie/e8d47bb440139d9f6c90acfd234e2fe6a668ba3d'
15:21:25 *** Error code 2
15:21:25 
15:21:25 Stop.
15:21:25 make: stopped in /home/jenkins/workspace/PostGIS_Worker_Run/label/bessie/e8d47bb440139d9f6c90acfd234e2fe6a668ba3d
15:21:26 Build step 'Execute shell' marked build as failure
15:21:26 [Gitea] do not publish assets due to build being non-Successfully
15:21:26 Finished: FAILURE

perhaps plpgsql needs to be installed separately like I need a postgresql-contrib

[robe]

Okay I think I might have figured out the issue, it's so annoying.

I tried to install PostgreSQL 17, but installing GDAL removed it cause GDAL 3.9.2 was compiled against PostgreSQL 16 client. And if I try to install GDAL, it removes PostgreSQL 17

So anyway just living with 16 as follows

pkg install postgresql16-server postgresql16-contrib gdal

I'm going to rerun on server in a bit, but hopping into bessie and running the last regress seemed to work.

I have pramsey, strk, cvvergara keys installed in jenkins account (planning to eventually use for pgrouting as well). So to hop in as mentioned its.

ssh jenkins@osgeo8-bessie

Following instructions in - ​https://wiki.osgeo.org/wiki/SAC_Service_Status#Logging_into_LXD_Containers_and_VMs

I'll close this as soon as I have a clean regress via jenkins.

[robe]

Forgot to mention, I haven't figured out how to install LXD agent on freebsd seems a bit complicated. As such doing

lxc exec bessie bash

doesn't work. I can only do it via lxc console.