Hi,
It makes sense, so I attach the new diff without these lines.
Thank you,
Regards
Adrián Escoms
On Wed, Nov 15, 2017 at 10:30 PM, Robert Haas <[email protected]> wrote:
> On Wed, Sep 13, 2017 at 11:50 AM, Adrian Escoms <[email protected]>
> wrote:
> > 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.
>
> I think this is a good idea, except I'd leave out this hunk:
>
> @@ -105,7 +105,7 @@
>
>
> #-----------------------------------------------------------
> -------------------
> -# RESOURCE USAGE (except WAL)
> +# RESOURCE USAGE
> #-----------------------------------------------------------
> -------------------
>
> # - Memory -
>
> I think a parenthetical gloss is a little different than different
> text, and not out of place in what is after all a sample file intended
> to be read by humans.
>
> --
> Robert Haas
> EnterpriseDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>
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
@@ -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 -
