[PostGIS] #5689: Set PostGIS windows bundle environment for service rather than machine.

[PostGIS]

#5689: Set PostGIS windows bundle environment for service rather than machine.
-------------------------+-------------------------------
 Reporter:  slefranc     |      Owner:  strk
     Type:  enhancement  |     Status:  new
 Priority:  medium       |  Milestone:  PostGIS Packaging
Component:  install      |    Version:  3.3.x
 Keywords:  windows      |
-------------------------+-------------------------------
 The PostGIS Windows bundle (postgis-bundle-pg15x64-setup-3.3.2-2.exe) asks
 the user if they want to set environment variables during installation.

 The environment is set at the machine level. This works for PostGIS
 itself, but can cause conflicts with other geospatial software. In our
 case, the GDAL variables (GDAL_DATA and PROJ_LIB) were conflicting with
 R's own GDAL libraries.

 I was able to set the environment at the service level instead:

 {{{
 path:
 HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\postgresql-x64-15
 name: Environment
 REG_MULTI_SZ:
       GDAL_DATA=C:\Program Files\PostgreSQL\15\gdal-data
       POSTGIS_ENABLE_OUTDB_RASTERS=1
       POSTGIS_GDAL_ENABLED_DRIVERS=GTiff PNG JPEG GIF XYZ DTED USGSDEM
 AAIGrid
       PROJ_LIB=C:\Program
 Files\PostgreSQL\15\share\contrib\postgis-3.3\proj
 }}}

 This has worked so far in our teaching lab setup, but I haven't done
 thorough testing of all PostGIS functions.

 Would it be possible to have the installer set the environment like this
 instead of globally, assuming it passes broader tests?
-- 
Ticket URL: <https://trac.osgeo.org/postgis/ticket/5689>
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.