[PostGIS] #5803: Setup new bessie on osgeo8

[PostGIS]

#5803: Setup new bessie on osgeo8
---------------------------+--------------------------------------
  Reporter:  robe          |      Owner:  robe
      Type:  defect        |     Status:  new
  Priority:  medium        |  Milestone:  Website Management, Bots
 Component:  QA/buildbots  |    Version:  master
Resolution:                |   Keywords:
---------------------------+--------------------------------------
Comment (by 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
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5803#comment:1>
PostGIS <http://trac.osgeo.org/postgis/>
The PostGIS Trac is used for bug, enhancement & task tracking, a user and developer wiki, and a view into the subversion code repository of PostGIS project.