Hi,
I realized that the parameter 'shared_preload_libraries' used to belong to
category 'Resource Usage / Kernel Resources' but since postgresql version
9.4 it was changed in pg_settings to 'Client Connection Defaults / Shared
Library Preloading' but in postgresql.conf it remains unchanged.
I attach the updated postgresql.conf.sample.diff with this change.
Regards
Adrián Escoms
On Wed, Sep 13, 2017 at 11:51 AM, Adrian Escoms <adesc...@ongres.com> wrote:
> Hello,
>
> We are working with postgresql.conf configuration file and we have found
> some discrepancies between it and pg_settings in terms of categories and
> subcategories (we have split the field category in pg_settings by '/', the
> first part being 'category', the second 'subcategory')
> We suggest to change the postgresql.conf.sample file with the attached
> diff to resolve these inconsistencies.
> We think that these changes could also be backported to previous
> versions.
>
> Looking forward to your comments,
>
>
> Adrián Escoms
>
diff --git a/src/backend/utils/misc/postgresql.conf.sample
b/src/backend/utils/misc/postgresql.conf.sample
index 53aa006..49d8b91 100644
--- a/src/backend/utils/misc/postgresql.conf.sample
+++ b/src/backend/utils/misc/postgresql.conf.sample
@@ -105,7 +105,7 @@
#------------------------------------------------------------------------------
-# RESOURCE USAGE (except WAL)
+# RESOURCE USAGE
#------------------------------------------------------------------------------
# - Memory -
@@ -138,11 +138,10 @@
#temp_file_limit = -1 # limits per-process temp file space
# in kB, or -1 for no limit
-# - Kernel Resource Usage -
+# - Kernel Resource -
#max_files_per_process = 1000 # min 25
# (change requires restart)
-#shared_preload_libraries = '' # (change requires restart)
# - Cost-Based Vacuum Delay -
@@ -172,7 +171,7 @@
#------------------------------------------------------------------------------
-# WRITE AHEAD LOG
+# WRITE-AHEAD LOG
#------------------------------------------------------------------------------
# - Settings -
@@ -228,7 +227,7 @@
# REPLICATION
#------------------------------------------------------------------------------
-# - Sending Server(s) -
+# - Sending Servers -
# Set these on the master and on any standby that will send replication data.
@@ -336,7 +335,7 @@
#------------------------------------------------------------------------------
-# ERROR REPORTING AND LOGGING
+# REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
@@ -471,8 +470,9 @@
# -1 disables, 0 logs all temp files
#log_timezone = 'GMT'
-
-# - Process Title -
+#------------------------------------------------------------------------------
+# PROCESS TITLE
+#------------------------------------------------------------------------------
#cluster_name = '' # added to process titles if nonempty
# (change requires restart)
@@ -480,10 +480,10 @@
#------------------------------------------------------------------------------
-# RUNTIME STATISTICS
+# STATISTICS
#------------------------------------------------------------------------------
-# - Query/Index Statistics Collector -
+# - Query and Index Statistics Collector -
#track_activities = on
#track_counts = on
@@ -493,7 +493,7 @@
#stats_temp_directory = 'pg_stat_tmp'
-# - Statistics Monitoring -
+# - Monitoring -
#log_parser_stats = off
#log_planner_stats = off
@@ -502,7 +502,7 @@
#------------------------------------------------------------------------------
-# AUTOVACUUM PARAMETERS
+# AUTOVACUUM
#------------------------------------------------------------------------------
#autovacuum = on # Enable autovacuum subprocess? 'on'
@@ -587,12 +587,16 @@
# default configuration for text search
#default_text_search_config = 'pg_catalog.simple'
-# - Other Defaults -
+# - Shared Library Preloading -
-#dynamic_library_path = '$libdir'
+#shared_preload_libraries = '' # (change requires restart)
#local_preload_libraries = ''
#session_preload_libraries = ''
+# - Other Defaults -
+
+#dynamic_library_path = '$libdir'
+
#------------------------------------------------------------------------------
# LOCK MANAGEMENT
@@ -610,7 +614,7 @@
#------------------------------------------------------------------------------
-# VERSION/PLATFORM COMPATIBILITY
+# VERSION AND PLATFORM COMPATIBILITY
#------------------------------------------------------------------------------
# - Previous PostgreSQL Versions -
--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers
