PostGIS 3.5.0alpha2 released supports PG17

[Greg Troxel]

"Regina Obe" <lr at pcorp.us> writes:

> https://postgis.net/2024/07/PostGIS-3.5.0alpha2/
>
> NEWS: https://git.osgeo.org/gitea/postgis/postgis/raw/tag/3.5.0alpha2/NEWS
> Source: https://download.osgeo.org/postgis/source/postgis-3.5.0alpha2.tar.gz

Maybe you want this in the tracker, but it's all over the place so seems
more helpful to just comment broadly to start:

  I have pgsql 12 installed on NetBSD 10 amd64, with geo prereqs
  basically at latest release.

  package update uneventual; just new sql files as usual

  make test has one failure, and I don't think this is a regression,
  just something I have not chased down.  But really this is pretty good.

      Test: test_spheroid_distance ...FAILED
      1. cu_geodetic.c:1355  - CU_ASSERT_DOUBLE_EQUAL(d,10001965.7293127228117396,epsilon)


      Run Summary:    Type  Total    Ran Passed Failed Inactive
                   suites     46     46    n/a      0        0
                    tests    339    339    338      1        0
                  asserts   5471   5471   5470      1      n/a

  NEWS says "DocBook5 XSL is now required to build html (Sandro
  Santilli)".  pkgsrc has docbook-xsl-1.79.2.  README.postgis gives a
  debian package name but doesn't describe it, and there's a "-ns"
  suffix.  So this is sort of a doc bug report.  Looking quickly it
  seems that the docbook-xsl situation is messy.   Is it really the case
  that almost every packaging system has this already?

  When docs are selected and the build fails, the overall build seems to
  exit 0 anyway, so I didn't notice that the docs build failed.
  Probably it failed and I didn't notice long ago and there are no docs
  installed and thus not in our PLIST.

  This is the doc build log run through uniq -c, because otherwise it's
  almost a megabyte.  Probably this is at least partially "docbook 5
  missing".   But it's a big list of binary plugins - are they part of
  docbook5 xsl, or ?

    1 /tmp/work/databases/postgresql-postgis2/work/.tools/bin/gmake -C doc html
    1 gmake[2]: Entering directory '/tmp/work/databases/postgresql-postgis2/work/postgis-3.5.0alpha2/doc'
    1 /usr/pkg/bin/xsltproc --path .:/tmp/work/databases/postgresql-postgis2/work/postgis-3.5.0alpha2/doc --param section.autolabel 1 --param section.label.includes.component.label 1 --param chunk.section.depth 0 --param generate.section.toc.level 2 --param toc.section.depth 1 --param funcsynopsis.style kr --param admon.graphics 1 --param admon.textlabel 0 --param make.clean.html 1 --param simplesect.in.toc 0 --param use.id.as.filename 1 --param chunk.quietly 1 --param header.rule 0 --param footer.rule 0 --param table.borders.with.css 1 --stringparam docbook.css.source "" --stringparam html.ext .html --stringparam saxon.character.representation decimal --timing \
    1 	--stringparam html.stylesheet style.css \
    1 	--output /tmp/work/databases/postgresql-postgis2/work/postgis-3.5.0alpha2/doc/html/postgis-en.html \
    1 	/usr/pkg/share/xsl/docbook/xhtml5/docbook.xsl \
    1 	postgis-out.xml
    1 Parsing stylesheet /usr/pkg/share/xsl/docbook/xhtml5/docbook.xsl took 0 ms
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/freshmeat_net_projects_freshmeat_submit.so
   27 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xsl_documentation_1_0.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/exslt_org_dates_and_times.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/exslt_org_common.so
    4 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xsl_documentation_1_0.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/exslt_org_common.so
    2 module error : failed to open /usr/pkg/lib/libxslt-plugins/xml_apache_org_xslt.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xslt_ext_com_nwalsh_saxon_TextFactory.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/com_nwalsh_xalan_Text.so
    2 module error : failed to open /usr/pkg/lib/libxslt-plugins/xml_apache_org_xslt.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xsl_documentation_1_0.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/xml_apache_org_xslt.so
   30 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xsl_documentation_1_0.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/xml_apache_org_xalan_redirect.so
    1 module error : failed to open /usr/pkg/lib/libxslt-plugins/xml_apache_org_xslt.so
    2 error : Unknown IO error
    1 postgis-out.xml:78: warning: failed to load external entity "http://docbook.org/xml/5.0/dtd/docbook.dtd"
    1 ]>
    1   ^
    1 Parsing document postgis-out.xml took 432 ms
    1 Note: namesp. cut : stripped namespace before processing           PostGIS 3.5.0alpha2 Manual
 7651 module error : failed to open /usr/pkg/lib/libxslt-plugins/nwalsh_com_xslt_ext_com_nwalsh_saxon_UnwrapLinks.so
    1 Running stylesheet and saving result took 7260 ms
    1 gmake[2]: Leaving directory '/tmp/work/databases/postgresql-postgis2/work/postgis-3.5.0alpha2/doc'