Mark change-on-restart-only values in postgresql.conf

I added additional comments marked setting which need server restart to
take effect. I use (!RSR!) tag for it, however if anybody have different
idea, let me know and I will change it.

I removed comments about commenting out behavior too, because patch now
waiting for commit (or reject?).


    Zdenek
Index: backend/utils/misc/postgresql.conf.sample
===================================================================
RCS file: /projects/cvsroot/pgsql/src/backend/utils/misc/postgresql.conf.sample,v
retrieving revision 1.182
diff -c -r1.182 postgresql.conf.sample
*** backend/utils/misc/postgresql.conf.sample    27 Jun 2006 22:16:44 -0000    1.182
--- backend/utils/misc/postgresql.conf.sample    18 Jul 2006 21:38:30 -0000
***************
*** 11,19 ****
  # allowed values can be found in the PostgreSQL documentation. The
  # commented-out settings shown in this file represent the default values.
  #
- # Please note that re-commenting a setting is NOT sufficient to revert it
- # to the default value, unless you restart the postmaster.
- #
  # Any option can also be given as a command line switch to the
  # postmaster, e.g. 'postmaster -c log_connections=on'. Some options
  # can be changed at run-time with the 'SET' SQL command.
--- 11,16 ----
***************
*** 22,28 ****
  # receives a SIGHUP. If you edit the file on a running system, you have
  # to SIGHUP the postmaster for the changes to take effect, or use
  # "pg_ctl reload". Some settings, such as listen_addresses, require
! # a postmaster shutdown and restart to take effect.


  #---------------------------------------------------------------------------
--- 19,26 ----
  # receives a SIGHUP. If you edit the file on a running system, you have
  # to SIGHUP the postmaster for the changes to take effect, or use
  # "pg_ctl reload". Some settings, such as listen_addresses, require
! # a postmaster shutdown and restart to take effect. This kind of items are
! # marked with (!RSR!) tag.


  #---------------------------------------------------------------------------
***************
*** 31,36 ****
--- 29,35 ----

  # The default values of these variables are driven from the -D command line
  # switch or PGDATA environment variable, represented here as ConfigDir.
+ # All file locations settings change require server restart to tak effect.

  #data_directory = 'ConfigDir'        # use data in another directory
  #hba_file = 'ConfigDir/pg_hba.conf'    # host-based authentication file
***************
*** 45,55 ****
  #---------------------------------------------------------------------------

  # - Connection Settings -

  #listen_addresses = 'localhost'        # what IP address(es) to listen on;
                      # comma-separated list of addresses;
                      # defaults to 'localhost', '*' = all
! #port = 5432
  #max_connections = 100
  # note: increasing max_connections costs ~400 bytes of shared memory per
  # connection slot, plus lock space (see max_locks_per_transaction).  You
--- 44,55 ----
  #---------------------------------------------------------------------------

  # - Connection Settings -
+ # All connection settings change will take effect after server restart.

  #listen_addresses = 'localhost'        # what IP address(es) to listen on;
                      # comma-separated list of addresses;
                      # defaults to 'localhost', '*' = all
! #port = 5432            # (!RSR!)
  #max_connections = 100
  # note: increasing max_connections costs ~400 bytes of shared memory per
  # connection slot, plus lock space (see max_locks_per_transaction).  You
***************
*** 63,73 ****
  # - Security & Authentication -

  #authentication_timeout = 60        # 1-600, in seconds
! #ssl = off
  #password_encryption = on
  #db_user_namespace = off

! # Kerberos
  #krb_server_keyfile = ''
  #krb_srvname = 'postgres'
  #krb_server_hostname = ''        # empty string matches any keytab entry
--- 63,73 ----
  # - Security & Authentication -

  #authentication_timeout = 60        # 1-600, in seconds
! #ssl = off                            # (!RSR!)
  #password_encryption = on
  #db_user_namespace = off

! # Kerberos (changes in kerberos setting require server restart)
  #krb_server_keyfile = ''
  #krb_srvname = 'postgres'
  #krb_server_hostname = ''        # empty string matches any keytab entry
***************
*** 90,98 ****

  # - Memory -

! #shared_buffers = 1000            # min 16 or max_connections*2, 8KB each
  #temp_buffers = 1000            # min 100, 8KB each
! #max_prepared_transactions = 5        # can be 0 or more
  # note: increasing max_prepared_transactions costs ~600 bytes of shared memory
  # per transaction slot, plus lock space (see max_locks_per_transaction).
  #work_mem = 1024            # min 64, size in KB
--- 90,98 ----

  # - Memory -

! #shared_buffers = 1000            # min 16 or max_connections*2, 8KB each (!RSR!)
  #temp_buffers = 1000            # min 100, 8KB each
! #max_prepared_transactions = 5        # can be 0 or more  (!RSR!)
  # note: increasing max_prepared_transactions costs ~600 bytes of shared memory
  # per transaction slot, plus lock space (see max_locks_per_transaction).
  #work_mem = 1024            # min 64, size in KB
***************
*** 101,113 ****

  # - Free Space Map -

! #max_fsm_pages = 20000            # min max_fsm_relations*16, 6 bytes each
! #max_fsm_relations = 1000        # min 100, ~70 bytes each

  # - Kernel Resource Usage -

! #max_files_per_process = 1000        # min 25
! #preload_libraries = ''

  # - Cost-Based Vacuum Delay -

--- 101,113 ----

  # - Free Space Map -

! #max_fsm_pages = 20000            # min max_fsm_relations*16, 6 bytes each (!RSR!)
! #max_fsm_relations = 1000        # min 100, ~70 bytes each (!RSR)

  # - Kernel Resource Usage -

! #max_files_per_process = 1000        # min 25 (!RSR!)
! #preload_libraries = ''                # (!RSR!)

  # - Cost-Based Vacuum Delay -

***************
*** 141,147 ****
                      #   fsync_writethrough
                      #   open_sync
  #full_page_writes = on            # recover from partial page writes
! #wal_buffers = 8            # min 4, 8KB each
  #commit_delay = 0            # range 0-100000, in microseconds
  #commit_siblings = 5            # range 1-1000

--- 141,147 ----
                      #   fsync_writethrough
                      #   open_sync
  #full_page_writes = on            # recover from partial page writes
! #wal_buffers = 8            # min 4, 8KB each (!RSR!)
  #commit_delay = 0            # range 0-100000, in microseconds
  #commit_siblings = 5            # range 1-1000

***************
*** 212,218 ****

  # This is used when logging to stderr:
  #redirect_stderr = off            # Enable capturing of stderr into log
!                     # files

  # These are only used if redirect_stderr is on:
  #log_directory = 'pg_log'        # Directory where log files are written
--- 212,218 ----

  # This is used when logging to stderr:
  #redirect_stderr = off            # Enable capturing of stderr into log
!                     # files (!RSR!)

  # These are only used if redirect_stderr is on:
  #log_directory = 'pg_log'        # Directory where log files are written
***************
*** 284,290 ****
                      # and their durations, in milliseconds.

  #silent_mode = off            # DO NOT USE without syslog or
!                     # redirect_stderr

  # - What to Log -

--- 284,290 ----
                      # and their durations, in milliseconds.

  #silent_mode = off            # DO NOT USE without syslog or
!                     # redirect_stderr (!RSR!)

  # - What to Log -

***************
*** 325,334 ****
  #stats_command_string = on
  #update_process_title = on

! #stats_start_collector = on        # needed for block or row stats
  #stats_block_level = off
  #stats_row_level = off
! #stats_reset_on_server_start = off


  # - Statistics Monitoring -
--- 325,334 ----
  #stats_command_string = on
  #update_process_title = on

! #stats_start_collector = on        # needed for block or row stats (!RSR!)
  #stats_block_level = off
  #stats_row_level = off
! #stats_reset_on_server_start = off    # (!RSR!)


  # - Statistics Monitoring -
***************
*** 403,409 ****
  #---------------------------------------------------------------------------

  #deadlock_timeout = 1000        # in milliseconds
! #max_locks_per_transaction = 64        # min 10
  # note: each lock table slot uses ~270 bytes of shared memory, and there are
  # max_locks_per_transaction * (max_connections + max_prepared_transactions)
  # lock table slots.
--- 403,409 ----
  #---------------------------------------------------------------------------

  #deadlock_timeout = 1000        # in milliseconds
! #max_locks_per_transaction = 64        # min 10 (!RSR!)
  # note: each lock table slot uses ~270 bytes of shared memory, and there are
  # max_locks_per_transaction * (max_connections + max_prepared_transactions)
  # lock table slots.