From 87c52d0264dfd99d417507f481516d0ebba39d3f Mon Sep 17 00:00:00 2001 From: "Karl O. Pinc kop@karlpinc.com" Date: Wed, 24 Jan 2024 22:50:33 +0000 Subject: [PATCH] default_transaction_deferrable=on, backslash_quote=off --- db/az_server_info | 150 +++++++++++++++++++++++++++++++++++++++------- 1 file changed, 129 insertions(+), 21 deletions(-) diff --git a/db/az_server_info b/db/az_server_info index 0f883a3..0b24e3e 100644 --- a/db/az_server_info +++ b/db/az_server_info @@ -684,7 +684,7 @@ "value": "on" }, { - "allowedValues": ",address_standardizer,address_standardizer_data_us,amcheck,bloom,btree_gin,btree_gist,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hstore,hypopg,intagg,intarray,isn,lo,ltree,orafce,pageinspect,pg_buffercache,pg_cron,pg_freespacemap,pg_hint_plan,pg_partman,pg_prewarm,pg_repack,pg_stat_statements,pg_trgm,pg_visibility,pgaudit,pgcrypto,pglogical,pgrouting,pgrowlocks,pgstattuple,plpgsql,plv8,postgis,postgis_raster,postgis_sfcgal,postgis_tiger_geocoder,postgis_topology,postgres_fdw,semver,sslinfo,tablefunc,timescaledb,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp,vector", + "allowedValues": ",address_standardizer,address_standardizer_data_us,amcheck,azure_ai,azure_storage,bloom,btree_gin,btree_gist,citext,cube,dblink,dict_int,dict_xsyn,earthdistance,fuzzystrmatch,hstore,hypopg,intagg,intarray,isn,lo,login_hook,ltree,orafce,pageinspect,pg_buffercache,pg_cron,pg_freespacemap,pg_hint_plan,pg_partman,pg_prewarm,pg_repack,pg_stat_statements,pg_trgm,pg_visibility,pgaudit,pgcrypto,pglogical,pgrouting,pgrowlocks,pgstattuple,plpgsql,plv8,postgis,postgis_raster,postgis_sfcgal,postgis_tiger_geocoder,postgis_topology,postgres_fdw,semver,sslinfo,tablefunc,tds_fdw,timescaledb,tsm_system_rows,tsm_system_time,unaccent,uuid-ossp,vector", "dataType": "Set", "defaultValue": "", "description": "Specifies which extensions are allowed to be created in the server.", @@ -719,6 +719,60 @@ "unit": null, "value": "off" }, + { + "allowedValues": "on,off", + "dataType": "Boolean", + "defaultValue": "on", + "description": "Allow accessing data from blob storage in extension azure_storage.", + "documentationLink": null, + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/azure_storage.allow_network_access", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": false, + "name": "azure_storage.allow_network_access", + "resourceGroup": "DBResources", + "source": "system-default", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": null, + "value": "on" + }, + { + "allowedValues": "1-4000", + "dataType": "Integer", + "defaultValue": "256", + "description": "Blob block size in megabytes for blob_put in extension azure_storage.", + "documentationLink": "https://learn.microsoft.com/en-us/rest/api/storageservices/put-block?tabs=azure-ad#remarks", + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/azure_storage.blob_block_size_mb", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": true, + "name": "azure_storage.blob_block_size_mb", + "resourceGroup": "DBResources", + "source": "system-default", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": "megabytes", + "value": "256" + }, + { + "allowedValues": "on,off", + "dataType": "Boolean", + "defaultValue": "on", + "description": "Allow all users to access data from public storage accounts in extension azure_storage.", + "documentationLink": null, + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/azure_storage.public_account_access", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": false, + "name": "azure_storage.public_account_access", + "resourceGroup": "DBResources", + "source": "system-default", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": null, + "value": "on" + }, { "allowedValues": "0-256", "dataType": "Integer", @@ -749,11 +803,11 @@ "isReadOnly": false, "name": "backslash_quote", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "safe_encoding" + "value": "off" }, { "allowedValues": ".*", @@ -1775,11 +1829,11 @@ "isReadOnly": false, "name": "default_transaction_deferrable", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "off" + "value": "on" }, { "allowedValues": "serializable,repeatable read,read committed,read uncommitted", @@ -4592,7 +4646,7 @@ { "allowedValues": "15-10080", "dataType": "Integer", - "defaultValue": "15", + "defaultValue": "720", "description": "Sets the query_store index auto generation interval in minutes for pg_qs.", "documentationLink": null, "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/pg_qs.index_generation_interval", @@ -4605,7 +4659,7 @@ "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": "minutes", - "value": "15" + "value": "720" }, { "allowedValues": "1-30", @@ -5580,7 +5634,7 @@ "value": "on" }, { - "allowedValues": "[A-Za-z0-9.\"$, ]+", + "allowedValues": "[A-Za-z0-9.\"$,_ ]+", "dataType": "String", "defaultValue": "\"$user\", public", "description": "Sets the schema search order for names that are not schema-qualified.", @@ -5663,11 +5717,11 @@ "isReadOnly": true, "name": "server_version", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "15.3" + "value": "15.4" }, { "allowedValues": "150003-150003", @@ -5681,22 +5735,22 @@ "isReadOnly": true, "name": "server_version_num", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "150003" + "value": "150004" }, { - "allowedValues": ".*", - "dataType": "String", + "allowedValues": ",login_hook", + "dataType": "Set", "defaultValue": "", "description": "Lists shared libraries to preload into each backend.", "documentationLink": null, "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/session_preload_libraries", "isConfigPendingRestart": false, "isDynamicConfig": true, - "isReadOnly": true, + "isReadOnly": false, "name": "session_preload_libraries", "resourceGroup": "DBResources", "source": "system-default", @@ -5796,7 +5850,7 @@ "value": "mmap" }, { - "allowedValues": ",auto_explain,pg_cron,pg_hint_plan,pg_partman_bgw,pg_prewarm,pg_stat_statements,pgaudit,pglogical,timescaledb,wal2json", + "allowedValues": ",auto_explain,azure_storage,pg_cron,pg_failover_slots,pg_hint_plan,pg_partman_bgw,pg_prewarm,pg_stat_statements,pgaudit,pglogical,timescaledb,wal2json", "dataType": "Set", "defaultValue": "pg_cron,pg_stat_statements", "description": "Sets which shared libraries are preloaded at server start.", @@ -6020,7 +6074,7 @@ "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/ssl_min_protocol_version", "isConfigPendingRestart": false, "isDynamicConfig": true, - "isReadOnly": true, + "isReadOnly": false, "name": "ssl_min_protocol_version", "resourceGroup": "DBResources", "source": "system-default", @@ -6401,11 +6455,11 @@ "isReadOnly": false, "name": "temp_tablespaces", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "" + "value": "temptblspace" }, { "allowedValues": "[A-Za-z0-9/+_-]+", @@ -6635,11 +6689,11 @@ "isReadOnly": true, "name": "transaction_deferrable", "resourceGroup": "DBResources", - "source": "system-default", + "source": "user-override", "systemData": null, "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", "unit": null, - "value": "off" + "value": "on" }, { "allowedValues": "serializable,repeatable read,read committed,read uncommitted", @@ -7415,6 +7469,42 @@ "unit": null, "value": "off" }, + { + "allowedValues": "1-7", + "dataType": "Integer", + "defaultValue": "3", + "description": "Sets the retention period window in days for server logs - after this time data will be deleted.", + "documentationLink": null, + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/logfiles.retention_days", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": false, + "name": "logfiles.retention_days", + "resourceGroup": "DBResources", + "source": "user-override", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": null, + "value": "1" + }, + { + "allowedValues": "on,off", + "dataType": "Boolean", + "defaultValue": "off", + "description": "Enables or disables server logs. off means server logs functionality isn't avaible to be turned on.", + "documentationLink": null, + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/logfiles.download_enable", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": false, + "name": "logfiles.download_enable", + "resourceGroup": "DBResources", + "source": "system-default", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": null, + "value": "off" + }, { "allowedValues": "on,off", "dataType": "Boolean", @@ -7505,6 +7595,24 @@ "unit": null, "value": "off" }, + { + "allowedValues": "off,recommend", + "dataType": "Enumeration", + "defaultValue": "off", + "description": "Enables or disables index recommendations. pg_qs.query_capture_mode must also be 'TOP' or 'ALL'.", + "documentationLink": null, + "id": "/subscriptions/94cd8cb7-d645-497b-b140-b281f40a5c96/resourceGroups/DBResources/providers/Microsoft.DBforPostgreSQL/flexibleServers/sokwe-dbs/configurations/pg_qs.index_recommendations", + "isConfigPendingRestart": false, + "isDynamicConfig": true, + "isReadOnly": false, + "name": "pg_qs.index_recommendations", + "resourceGroup": "DBResources", + "source": "system-default", + "systemData": null, + "type": "Microsoft.DBforPostgreSQL/flexibleServers/configurations", + "unit": null, + "value": "off" + }, { "allowedValues": "true, false", "dataType": "Boolean", -- 2.34.1