[SCM] PostGIS branch stable-3.4 updated. 3.4.2-10-gaf10c4a54

[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".

The branch, stable-3.4 has been updated
       via  af10c4a540b98829394f0a7c9472868c2c7eaac0 (commit)
      from  31722bfdc04e353f9c94b53402aecc9d0f142c2c (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 af10c4a540b98829394f0a7c9472868c2c7eaac0
Author: jayaddison <jay+osgeo at jp-hosting.net>
Date:   Sun Mar 10 09:27:07 2024 -0700

    Apply extension-upgrade-sql-reproducible.patch from trac ticket #5666
    
    This patch is intended to remove a source of non-deterministic build
    output, by reading the SOURCE_DATE_EPOCH[1] build-time-indicator
    variable and using the resulting value instead of the build-host's
    clock as a timestamp in extension upgrade script comments.
    
    The approach here borrows from a similar pattern[2] used in the
    'configure.ac' script.
    
    [1] - https://reproducible-builds.org/docs/source-date-epoch/
    
    [2] - https://git.osgeo.org/gitea/postgis/postgis/src/commit/0418cc0ddfda973ba10aa8cc981b07f25a464bdb/configure.ac#L1120
    
    Signed-off-by: jayaddison <jay+osgeo at jp-hosting.net>
    
    Closes #5666 for PostGIS 3.4.3

diff --git a/NEWS b/NEWS
index 21350ed95..4ef06ae1d 100644
--- a/NEWS
+++ b/NEWS
@@ -15,6 +15,8 @@ To take advantage of all SFCGAL featurs, SFCGAL 1.4.1+ is needed.
           set to off (Sandro Santilli)
  - #5589, ST_3DDistance error for shared first point (Paul Ramsey)
  - #5686, ST_NumInteriorRings and Triangle crash (Paul Ramsey)
+ - #5666, Build reproducibility: timestamps 
+          in extension upgrade SQL scripts (Jay Addison)
 
 
 PostGIS 3.4.2
diff --git a/doc/introduction.xml b/doc/introduction.xml
index 5b1c625e0..95acc1af3 100644
--- a/doc/introduction.xml
+++ b/doc/introduction.xml
@@ -274,6 +274,7 @@
 					<member>James Marca</member>
 					<member>Jan Katins</member>
 					<member>Jason Smith</member>
+					<member>Jay Addison</member>
 					<member>Jeff Adams</member>
 					<member>Jelte Fennema</member>
 					<member>Jim Jones</member>
diff --git a/extensions/upgrade-paths-rules.mk b/extensions/upgrade-paths-rules.mk
index c87a4e6c2..794957e8c 100644
--- a/extensions/upgrade-paths-rules.mk
+++ b/extensions/upgrade-paths-rules.mk
@@ -4,6 +4,8 @@ TAG_UPGRADE=$(EXTENSION)--TEMPLATED--TO--ANY.sql
 
 PG_SHAREDIR=$(shell $(PG_CONFIG) --sharedir)
 
+POSTGIS_BUILD_DATE=$(shell date $${SOURCE_DATE_EPOCH:+-d @$$SOURCE_DATE_EPOCH} -u "+%Y-%m-%d %H:%M:%S")
+
 install: install-upgrade-paths
 
 #
@@ -37,7 +39,7 @@ all: sql/$(TAG_UPGRADE)
 sql/$(TAG_UPGRADE): $(MAKEFILE_LIST) | sql
 	echo '-- Just tag extension $(EXTENSION) version as "ANY"' > $@
 	echo '-- Installed by $(EXTENSION) $(EXTVERSION)' >> $@
-	echo '-- Built on $(shell date)' >> $@
+	echo '-- Built on $(POSTGIS_BUILD_DATE)' >> $@
 
 uninstall: uninstall-upgrade-paths
 

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

Summary of changes:
 NEWS                              | 2 ++
 doc/introduction.xml              | 1 +
 extensions/upgrade-paths-rules.mk | 4 +++-
 3 files changed, 6 insertions(+), 1 deletion(-)


hooks/post-receive
-- 
PostGIS