[SCM] PostGIS Buildbots; Jenkins jobs and instructions for setting up winnie and debbie bots. branch master updated. fd680d0534a8f33863c577f6e6a8f1d90084bbd4

[git at osgeo.org]

This is an automated email from the git hooks/post-receive script. It was
generated because a ref change was pushed to the repository containing
the project "PostGIS Buildbots; Jenkins jobs and instructions for setting up winnie and debbie bots.".

The branch, master has been updated
       via  fd680d0534a8f33863c577f6e6a8f1d90084bbd4 (commit)
      from  79e81aca3cf11cbb77ef13ce371392e57a6830ae (commit)

Those revisions listed above that are new to this repository have
not appeared on any other notification email; so we list those
revisions in full, below.

- Log -----------------------------------------------------------------
commit fd680d0534a8f33863c577f6e6a8f1d90084bbd4
Author: Regina Obe <lr at pcorp.us>
Date:   Sat Nov 8 03:03:36 2025 -0500

    build script for pgsphere

diff --git a/windows/mingw64/scripts/build_pgsphere.sh b/windows/mingw64/scripts/build_pgsphere.sh
new file mode 100644
index 0000000..7ebaed8
--- /dev/null
+++ b/windows/mingw64/scripts/build_pgsphere.sh
@@ -0,0 +1,89 @@
+#export OS_BUILD=64
+#export GCC_TYPE=
+#export PG_VER=18
+export PROJECTS=/projects
+export PGPATH=${PROJECTS}/postgresql/rel/pg${PG_VER}w${OS_BUILD}${GCC_TYPE}
+export PGPATHEDB=${PGPATH}edb
+export PATH="/mingw/bin:/bin:/c/Windows/system32"
+export PATH="${PGPATH}/bin:${PGPATH}/lib:${PATH}" 
+#export PGPORT=5455
+export PGUSER=postgres
+export SOURCES=/sources
+export HEALPIX_VER=3.82.1
+export REL_HEALPIX=/projects/pgsphere/rel_healpix_${HEALPIX_VER}w${OS_BUILD}${GCC_TYPE}
+
+export CFITSIO_VER=4.6.3
+export REL_CFITSIO=/projects/pgsphere/rel_cfitsio_${CFITSIO_VER}w${OS_BUILD}${GCC_TYPE}
+cd /projects
+cd pgsphere/pgsphere
+
+
+# build cfitsio
+if false; then
+  wget -N https://heasarc.gsfc.nasa.gov/FTP/software/fitsio/c/cfitsio-${CFITSIO_VER}.tar.gz
+  export PATH="${PGPATH}/bin:${PGPATH}/lib:${PATH}" 
+  rm -rf cfitsio-${CFITSIO_VER}
+  tar xvf cfitsio-${CFITSIO_VER}.tar.gz
+  cd cfitsio-${CFITSIO_VER}
+  mkdir build
+  #./configure --prefix=${REL_CFITSIO}
+  cmake  -Bbuild -G"Ninja" -DCMAKE_BUILD_TYPE=Release -DCMAKE_INSTALL_PREFIX:PATH=REL_CFITSIO 
+  #cmake --build .
+  cmake --install .
+  exit
+fi
+# build healpix
+if false; then
+	export PATH="${PGPATH}/bin:${PGPATH}/lib:${REL_CFITSIO}/bin:${PATH}" 
+	wget -N https://sourceforge.net/projects/healpix/files/Healpix_3.82/healpix_cxx-${HEALPIX_VER}.tar.gz/download -O healpix_cxx-${HEALPIX_VER}.tar.gz
+	tar xvf healpix_cxx-${HEALPIX_VER}.tar.gz
+	cd healpix_cxx-${HEALPIX_VER}
+	./configure --prefix=${REL_HEALPIX}
+	exit
+fi
+#export PGSPHERE_VER=master
+#export PGSPHERE_VER=1.5.1
+
+#git clean -fdx
+#git reset --hard
+#git checkout ${PGSPHERE_VER}
+#git pull
+#clear
+export USE_PGXS=1
+#git checkout 1.4.0
+#git checkout ${PGSPHERE_VER}
+git pull
+git clean -fdx
+make clean
+#export USE_PGXS=1
+make USE_HEALPIX=0
+rm ${PGPATH}/lib/pg_sphere.dll
+make USE_HEALPIX=0 install
+cp pg_sphere.dll ${PGPATHEDB}/lib/
+
+make installcheck USE_HEALPIX=0
+
+export RELDIR=${PROJECTS}/pgsphere/binaries/
+export RELVERDIR=pgsphere-pg${PG_VER}-binaries-${PGSPHERE_VER}w${OS_BUILD}${GCC_TYPE}
+outdir="${RELDIR}/${RELVERDIR}"
+package="${outdir}.zip"
+verfile="${outdir}/pg_sphere_version.txt"
+rm -rf $outdir
+rm -f $package
+strip *.dll
+mkdir -p ${outdir}
+mkdir -p ${outdir}/lib
+mkdir -p ${outdir}/share/extension
+echo "PGSPHERE VERSION: ${PGSPHERE_VER} https://github.com/postgrespro/pgsphere.git $(git rev-parse HEAD)" >> $verfile
+echo "USE_HEALPIX=0" >> $verfile
+cp COPYRIGHT.pg_sphere ${outdir}
+cp *.dll ${outdir}/lib/
+cp *.control ${outdir}/share/extension/
+cp *.sql ${outdir}/share/extension/
+cd ${RELDIR}
+cp README ${outdir}
+zip -r $package ${RELVERDIR}
+md5sum ${RELVERDIR}.zip > ${package}.md5
+
+cp $package ${PROJECTS}/postgis/win_web/download/windows/pg${PG_VER}/buildbot/extras
+cp ${package}.md5 ${PROJECTS}/postgis/win_web/download/windows/pg${PG_VER}/buildbot/extras
\ No newline at end of file

-----------------------------------------------------------------------

Summary of changes:
 windows/mingw64/scripts/build_pgsphere.sh | 89 +++++++++++++++++++++++++++++++
 1 file changed, 89 insertions(+)
 create mode 100644 windows/mingw64/scripts/build_pgsphere.sh


hooks/post-receive
-- 
PostGIS Buildbots; Jenkins jobs and instructions for setting up winnie and debbie bots.