[PostGIS] #5666: Build reproducibility: timestamps in extension upgrade SQL scripts

[PostGIS]

#5666: Build reproducibility: timestamps in extension upgrade SQL scripts
----------------------------+--------------------
  Reporter:  James Addison  |      Owner:  strk
      Type:  defect         |     Status:  closed
  Priority:  medium         |  Milestone:
 Component:  build          |    Version:  3.4.x
Resolution:  fixed          |   Keywords:
----------------------------+--------------------
Changes (by Regina Obe <lr@…>):

 * status:  new => closed
 * resolution:   => fixed

Comment:

 In [changeset:"af10c4a540b98829394f0a7c9472868c2c7eaac0/git" af10c4a/git]:
 {{{#!CommitTicketReference repository="git"
 revision="af10c4a540b98829394f0a7c9472868c2c7eaac0"
 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
 }}}
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5666#comment:8>
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.