[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