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..99ec156 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,7 +138,7 @@
#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)
@@ -172,7 +172,7 @@
#------------------------------------------------------------------------------
-# WRITE AHEAD LOG
+# WRITE-AHEAD LOG
#------------------------------------------------------------------------------
# - Settings -
@@ -228,7 +228,7 @@
# REPLICATION
#------------------------------------------------------------------------------
-# - Sending Server(s) -
+# - Sending Servers -
# Set these on the master and on any standby that will send replication data.
@@ -336,7 +336,7 @@
#------------------------------------------------------------------------------
-# ERROR REPORTING AND LOGGING
+# REPORTING AND LOGGING
#------------------------------------------------------------------------------
# - Where to Log -
@@ -471,8 +471,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 +481,10 @@
#------------------------------------------------------------------------------
-# RUNTIME STATISTICS
+# STATISTICS
#------------------------------------------------------------------------------
-# - Query/Index Statistics Collector -
+# - Query and Index Statistics Collector -
#track_activities = on
#track_counts = on
@@ -493,7 +494,7 @@
#stats_temp_directory = 'pg_stat_tmp'
-# - Statistics Monitoring -
+# - Monitoring -
#log_parser_stats = off
#log_planner_stats = off
@@ -502,7 +503,7 @@
#------------------------------------------------------------------------------
-# AUTOVACUUM PARAMETERS
+# AUTOVACUUM
#------------------------------------------------------------------------------
#autovacuum = on # Enable autovacuum subprocess? 'on'
@@ -610,7 +611,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
