[postgis-users] Query postgis GUC variables on a new connection

[Jorge Gustavo Rocha]

Hi,

When I connect to a database, I can not query the postgis GUC variables
postgis.enable_outdb_rasters or postgis.gdal_enabled_drivers.

$ psql service=geotuga
psql (11.4 (Ubuntu 11.4-1.pgdg18.10+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits:
256, compression: off)

localhost:5432 geobox at geotuga=# show postgis.gdal_enabled_drivers;
ERROR:  42704: unrecognized configuration parameter
"postgis.gdal_enabled_drivers"
LOCATION:  GetConfigOptionByName, guc.c:8342
localhost:5432 geobox at geotuga=# show postgis.enable_outdb_rasters;
ERROR:  42704: unrecognized configuration parameter
"postgis.enable_outdb_rasters"
LOCATION:  GetConfigOptionByName, guc.c:8342
localhost:5432 geobox at geotuga=#

But if I run ST_GDALDrivers(), afterwards the variables can be queried.

$ psql service=geotuga
psql (11.4 (Ubuntu 11.4-1.pgdg18.10+1))
SSL connection (protocol: TLSv1.3, cipher: TLS_AES_256_GCM_SHA384, bits:
256, compression: off)

localhost:5432 geobox at geotuga=# SELECT short_name FROM ST_GDALDrivers()
LIMIT 1;
 short_name
------------
 VRT

localhost:5432 geobox at geotuga=# show postgis.enable_outdb_rasters;
 postgis.enable_outdb_rasters
------------------------------
 on

localhost:5432 geobox at geotuga=# show postgis.gdal_enabled_drivers;
 postgis.gdal_enabled_drivers
------------------------------
 ENABLE_ALL

My question is: aren't these variables already assigned? Why only after
ST_GDALDrivers() call are these variables defined?

Best regards

Jorge Gustavo
-- 
Jorge Gustavo Rocha
Departamento de Informática
Universidade do Minho
4710-057 Braga
Gabinete 3.29 (Piso 3)
Tel: +351 253604480
Fax: +351 253604471
Móvel: +351 910333888
skype: nabocudnosor