[SCM] PostGIS branch stable-3.5 updated. 3.5.0-20-g9e97a85fb

git at osgeo.org git at osgeo.org
Tue Oct 29 14:59:49 PDT 2024


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.5 has been updated
       via  9e97a85fbd192ea3460f38bc59be7db0b871286d (commit)
      from  69abb0721c7f4e551f0061de9293db61b83a0037 (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 9e97a85fbd192ea3460f38bc59be7db0b871286d
Author: Nikolai B <nikolai-b at users.noreply.github.com>
Date:   Tue Sep 24 12:20:08 2024 +0100

    - doc: unify gdal_enabled_drivers and enable_outdb_rasters
    - RO: add PostgreSQL manual links
    
    Closes https://github.com/postgis/postgis/pull/779

diff --git a/doc/reference_guc.xml b/doc/reference_guc.xml
index 4efc5b0c5..c0854c0b4 100644
--- a/doc/reference_guc.xml
+++ b/doc/reference_guc.xml
@@ -4,6 +4,8 @@
     <abstract>
     <para>This section lists custom PostGIS Grand Unified Custom Variables (GUC).
 These can be set globally, by database, by session or by transaction. Best set at global or database level.</para>
+<para>For more examples of usage refer to <link xlink:href="https://www.postgresql.org/docs/current/sql-set.html">SQL SET</link> 
+    and <link xlink:href="https://www.postgresql.org/docs/current/sql-altersystem.html">SQL ALTER SYSTEM</link></para>
     </abstract>
     </info>
 
@@ -149,30 +151,25 @@ SET postgis.gdal_datapath = 'C:/Program Files/PostgreSQL/9.3/gdal-data';</progra
 
             <refsection>
                 <title>Examples</title>
-                <para>Set and reset <varname>postgis.gdal_enabled_drivers</varname></para>
-
-                <para>Sets backend for all new connections to database</para>
-                <programlisting>ALTER DATABASE mygisdb SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';</programlisting>
-
-                <para>Sets default enabled drivers for all new connections to server. Requires super user access and PostgreSQL 9.4+.
-                    Also note that database, session, and user settings override this.</para>
-                <programlisting>ALTER SYSTEM SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';
-SELECT pg_reload_conf();
-                </programlisting>
+                <para>To set and reset <varname>postgis.gdal_enabled_drivers</varname> for current session</para>
 
                 <programlisting>
-SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';
+SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
 SET postgis.gdal_enabled_drivers = default;
                 </programlisting>
 
-                <para>Enable all GDAL Drivers</para>
-                <programlisting>
-SET postgis.gdal_enabled_drivers = 'ENABLE_ALL';
-                </programlisting>
+                <para>Set for all new connections to a specific database to specific drivers</para>
+
+                <programlisting>ALTER DATABASE mygisdb SET postgis.gdal_enabled_drivers TO 'GTiff PNG JPEG';</programlisting>
+
+                <para>Setting for whole database cluster to enable all drivers. Requires super user access.
+                    Also note that database, session, and user settings override this.</para>
 
-                <para>Disable all GDAL Drivers</para>
                 <programlisting>
-SET postgis.gdal_enabled_drivers = 'DISABLE_ALL';
+ --writes to postgres.auto.conf
+ALTER SYSTEM SET postgis.gdal_enabled_drivers TO 'ENABLE_ALL';
+ --Reloads postgres conf
+SELECT pg_reload_conf();
                 </programlisting>
             </refsection>
 
@@ -234,16 +231,17 @@ SET postgis.enable_outdb_rasters = True;
 SET postgis.enable_outdb_rasters = False;
                 </programlisting>
 
-                <para>Set for specific database</para>
+                <para>Set for all new connections to a specific database</para>
 
                 <programlisting>
 ALTER DATABASE gisdb SET postgis.enable_outdb_rasters = true;
                 </programlisting>
 
-                <para>Setting for whole database cluster. You need to reconnect to the database for changes to take effect.</para>
+                <para>Setting for whole database cluster. Requires super user access.
+                    Also note that database, session, and user settings override this.</para>
                 <programlisting>
  --writes to postgres.auto.conf
-ALTER SYSTEM postgis.enable_outdb_rasters = true;
+ALTER SYSTEM SET postgis.enable_outdb_rasters = true;
  --Reloads postgres conf
 SELECT pg_reload_conf();
                 </programlisting>

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

Summary of changes:
 doc/reference_guc.xml | 38 ++++++++++++++++++--------------------
 1 file changed, 18 insertions(+), 20 deletions(-)


hooks/post-receive
-- 
PostGIS


More information about the postgis-tickets mailing list