[postgis-tickets] [PostGIS] #5472: GEOS details seem wrong on demo.postgis.net

[PostGIS]

#5472: GEOS details seem wrong on demo.postgis.net
------------------------+---------------------------
  Reporter:  robe       |      Owner:  robe
      Type:  defect     |     Status:  closed
  Priority:  medium     |  Milestone:  PostGIS 3.4.0
 Component:  buildbots  |    Version:  master
Resolution:  fixed      |   Keywords:
------------------------+---------------------------
Comment (by robe):

 Okay I upgraded demo.postgis.net first to bookworm, but that only gave me
 GDAL 3.6.2.
 So I went wilder, and upgraded to the not yet released trixie, and now we
 have GDAL 3.7.1 :)


 {{{
 SELECT postgis_full_version(), version();
 }}}


 {{{
 POSTGIS="3.4.0dev 3.4.0rc1-11-g9376923fd" [EXTENSION] PGSQL="160"
 GEOS="3.12.0-CAPI-1.18.0" PROJ="9.2.1 NETWORK_ENABLED=OFF
 URL_ENDPOINT=https://cdn.proj.org USER_WRITABLE_DIRECTORY=/tmp/proj
 DATABASE_PATH=/usr/share/proj/proj.db" GDAL="GDAL 3.7.1, released
 2023/07/06" LIBXML="2.9.14" LIBJSON="0.16" LIBPROTOBUF="1.4.1"
 WAGYU="0.5.0 (Internal)" RASTER

 PostgreSQL 16beta2 (Debian 16~beta2-2.pgdg130+~20230807.1101.ge8386b2) on
 x86_64-pc-linux-gnu, compiled by gcc (Debian 13.2.0-1) 13.2.0, 64-bit
 }}}

 and look at the drivers available

 {{{
 SELECT ogr_fdw_version();
 SELECT f.name
 FROM unnest(ogr_fdw_drivers()) AS f(name)
 ORDER BY f.name;

 }}}


 {{{
 OGR_FDW="1.1" GDAL="3.7.1"

 -- 80 drivers with ogr_fdw extension, but sadly parquet is not one of them
 -- but at least GTFS is in there

 AmigoCloud
 AVCBin
 AVCE00
 BAG
 CAD
 Carto
 CSV
 CSW
 DGN
 DXF
 EDIGEO
 EEDA
 Elasticsearch
 ESRI Shapefile
 ESRIJSON
 FITS
 FlatGeobuf
 Geoconcept
 GeoJSON
 GeoJSONSeq
 GeoRSS
 GML
 GMLAS
 GPKG
 GPSBabel
 GPX
 GTFS
 HTTP
 Idrisi
 Interlis 1
 Interlis 2
 JML
 JP2OpenJPEG
 KML
 LIBKML
 LVBAG
 MapInfo File
 MapML
 MBTiles
 Memory
 MSSQLSpatial
 MVT
 MySQL
 NAS
 netCDF
 NGW
 OAPIF
 ODBC
 ODS
 OGCAPI
 OGR_GMT
 OGR_OGDI
 OGR_PDS
 OGR_SDTS
 OGR_VRT
 OpenFileGDB
 OSM
 PCIDSK
 PDF
 PDS4
 PGDUMP
 PGeo
 PLSCENES
 PostgreSQL
 S57
 Selafin
 SOSI
 SQLite
 SVG
 SXF
 TIGER
 TopoJSON
 UK .NTF
 VDV
 VFK
 VICAR
 WAsP
 WFS
 XLS
 XLSX
 }}}

 Maybe I should just bite the bullet and compile GDAL too.
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5472#comment:2>
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.