raster2pgsql file missing from postgis 3.0.0 on Windows 10

[robgskn]

Dear PostGIS,

Thank you for the great work you do. My fresh installs on Windows 10 of postgis 3.0.0 on Postgres 12 and Postgres 11.5 have failed to install any raster2pgsql.exe file in the PostgreSQL/11/bin or PostgreSQL/12/bin folder. I only get this file with a fresh install of postgis 2.5.*, not 3.0.0. Since the 3.0.0 user guide still states raster2pgsql is the normal way of loading rasters, I am stuck. thank you.

[robe]

Sorry not sure how I missed shipping that. I'll try to have another version out next week. Thanks for alerting.

[Regina Obe <lr@…>]

In b348507/git:

Include raster2pgsql in windows packaging - got left out since location it built got changed with liblwgeom changes evidentally. References #4570 for PostGIS 3.1

[robe]

I rebuilt the PostGIS 3.0.0 can find here:

​https://winnie.postgis.net/download/windows/

(11 one is - ​https://winnie.postgis.net/download/windows/pg11/buildbot/postgis-pg11-binaries-3.0.0w64gcc81.zip )

If you are in a rush - you can copy the raster2pgsql from there and it should work with your install.

I'm working on repackaging the installers

[Regina Obe <lr@…>]

In fcddfd5/git:

Include raster2pgsql in windows packaging. Closes #4570 for PostGIS 3.0

[robe]

I've redeployed installers for 12, 11, 10 windows 64-bit on application stackbuilder and ​https://download.osgeo.org/postgis/windows

You can just reinstall and you should get raster2pgsql as well as the other updates.

In addition it has updated GDAL and GDAL dependency libraries (which will affect both raster2pgsql, raster, and ogr_fdw)

GDAL VERSION: 2.4.3 https://github.com/OSGeo/gdal/blob/v2.4.3/gdal/NEWS
PROJ VERSION: 5.2.0 https://download.osgeo.org/proj/proj-5.2.0.tar.gz

ZLIB VERSION: 1.2.11 
SQLite3 VERSION: 3.30.1 #https://www.sqlite.org/2019/sqlite-amalgamation-3300100.zip
LibXML VERSION: 2.9.9  ftp://xmlsoft.org/libxml2/libxml2-2.9.9.tar.gz
OpenJPEG VERSION: 2.3.1  https://github.com/uclouvain/openjpeg/archive/v2.3.1.tar.gz
OpenSSL VERSION: 1.1.1c  https://www.openssl.org/source/openssl-1.1.1c.tar.gz
CUrl VERSION: 7.65.3 http://curl.haxx.se/download/curl-7.65.3.tar.gz
FreeXL VERSION: 1.0.5 http://www.gaia-gis.it/gaia-sins/freexl-1.0.5.tar.gz
Expat VERSIONL 2.2.9 https://github.com/libexpat/libexpat/blob/R_2_2_9/expat/Changes