Update sipb-xen-database for Postgres 8.3

svn path=/trunk/packages/sipb-xen-database/; revision=976

diff --git a/debian/changelog b/debian/changelog
index 24d4405..657db3e 100644 (file)
--- a/debian/changelog
+++ b/debian/changelog
@@ -1,3 +1,9 @@
+sipb-xen-database (10.24) unstable; urgency=low
+
+  * Update postgresql.conf for Hardy
+
+ -- Evan Broder <broder@mit.edu>  Wed, 01 Oct 2008 03:12:36 -0400
+

 sipb-xen-database (10.23) unstable; urgency=low
 
   * switch to postgresql 8.3, as 8.1 isn't in hardy
 sipb-xen-database (10.23) unstable; urgency=low
 
   * switch to postgresql 8.3, as 8.1 isn't in hardy

diff --git a/server/etc/postgresql/8.3/main/postgresql.conf.invirt b/server/etc/postgresql/8.3/main/postgresql.conf.invirt
index 9548b91..4883c2d 100644 (file)
--- a/server/etc/postgresql/8.3/main/postgresql.conf.invirt
+++ b/server/etc/postgresql/8.3/main/postgresql.conf.invirt
@@ -6,75 +6,89 @@
 #
 #   name = value
 #
 #
 #   name = value
 #

-# (The '=' is optional.) White space may be used. Comments are introduced
-# with '#' anywhere on a line. The complete list of option names and
-# allowed values can be found in the PostgreSQL documentation. The
-# commented-out settings shown in this file represent the default values.
+# (The "=" is optional.)  Whitespace may be used.  Comments are introduced with
+# "#" anywhere on a line.  The complete list of parameter names and allowed
+# values can be found in the PostgreSQL documentation.

 #
 #

-# Please note that re-commenting a setting is NOT sufficient to revert it
-# to the default value, unless you restart the postmaster.
+# The commented-out settings shown in this file represent the default values.
+# Re-commenting a setting is NOT sufficient to revert it to the default value;
+# you need to reload the server.

 #
 #

-# 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.
+# This file is read on server startup and when the server receives a SIGHUP
+# signal.  If you edit the file on a running system, you have to SIGHUP the
+# server for the changes to take effect, or use "pg_ctl reload".  Some
+# parameters, which are marked below, require a server shutdown and restart to
+# take effect.

 #
 #

-# This file is read on postmaster startup and when the postmaster
-# 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.
+# Any parameter can also be given as a command-line option to the server, e.g.,
+# "postgres -c log_connections=on".  Some paramters can be changed at run time
+# with the "SET" SQL command.
+#
+# Memory units:  kB = kilobytes MB = megabytes GB = gigabytes
+# Time units:    ms = milliseconds s = seconds min = minutes h = hours d = days

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # FILE LOCATIONS
 # FILE LOCATIONS

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 

-# The default values of these variables are driven from the -D command line
-# switch or PGDATA environment variable, represented here as ConfigDir.
+# The default values of these variables are driven from the -D command-line
+# option or PGDATA environment variable, represented here as ConfigDir.

 
 

-#data_directory = 'ConfigDir'          # use data in another directory
+data_directory = '/var/lib/postgresql/8.3/main'                # use data in another directory
+                                       # (change requires restart)

 hba_file = '/etc/postgresql/8.3/main/pg_hba.conf'      # host-based authentication file
 hba_file = '/etc/postgresql/8.3/main/pg_hba.conf'      # host-based authentication file

-ident_file = '/etc/postgresql/8.3/main/pg_ident.conf'  # IDENT configuration file
+                                       # (change requires restart)
+ident_file = '/etc/postgresql/8.3/main/pg_ident.conf'  # ident configuration file
+                                       # (change requires restart)

 
 

-# If external_pid_file is not explicitly set, no extra pid file is written.
-external_pid_file = '/var/run/postgresql/8.3-main.pid'         # write an extra pid file
+# If external_pid_file is not explicitly set, no extra PID file is written.
+external_pid_file = '/var/run/postgresql/8.3-main.pid'         # write an extra PID file
+                                       # (change requires restart)

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # CONNECTIONS AND AUTHENTICATION
 # CONNECTIONS AND AUTHENTICATION

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Connection Settings -
 
 
 # - Connection Settings -
 

-listen_addresses = '*'         # what IP address(es) to listen on; 
+listen_addresses = '*'                 # what IP address(es) to listen on;

                                        # comma-separated list of addresses;
                                        # defaults to 'localhost', '*' = all
                                        # 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
-# might also need to raise shared_buffers to support more connections.
-#superuser_reserved_connections = 2
-unix_socket_directory = '/var/run/postgresql'
-#unix_socket_group = ''
-#unix_socket_permissions = 0777                # octal
+                                       # (change requires restart)
+port = 5432                            # (change requires restart)
+max_connections = 100                  # (change requires restart)
+# Note:  Increasing max_connections costs ~400 bytes of shared memory per 
+# connection slot, plus lock space (see max_locks_per_transaction).  You might
+# also need to raise shared_buffers to support more connections.
+#superuser_reserved_connections = 3    # (change requires restart)
+unix_socket_directory = '/var/run/postgresql'          # (change requires restart)
+#unix_socket_group = ''                        # (change requires restart)
+#unix_socket_permissions = 0777                # begin with 0 to use octal notation
+                                       # (change requires restart)

 #bonjour_name = ''                     # defaults to the computer name
 #bonjour_name = ''                     # defaults to the computer name

+                                       # (change requires restart)

 
 

-# - Security & Authentication -
+# - Security and Authentication -

 
 

-#authentication_timeout = 60           # 1-600, in seconds
-ssl = true
+#authentication_timeout = 1min         # 1s-600s
+ssl = true                             # (change requires restart)
+#ssl_ciphers = 'ALL:!ADH:!LOW:!EXP:!MD5:@STRENGTH'     # allowed SSL ciphers
+                                       # (change requires restart)

 #password_encryption = on
 #db_user_namespace = off
 
 #password_encryption = on
 #db_user_namespace = off
 

-# Kerberos
-#krb_server_keyfile = ''
-#krb_srvname = 'postgres'
+# Kerberos and GSSAPI
+#krb_server_keyfile = ''               # (change requires restart)
+#krb_srvname = 'postgres'              # (change requires restart, Kerberos only)

 #krb_server_hostname = ''              # empty string matches any keytab entry
 #krb_server_hostname = ''              # empty string matches any keytab entry

-#krb_caseins_users = off
+                                       # (change requires restart, Kerberos only)
+#krb_caseins_users = off               # (change requires restart)
+#krb_realm = ''                        # (change requires restart)

 
 # - TCP Keepalives -
 
 # - TCP Keepalives -

-# see 'man 7 tcp' for details
+# see "man 7 tcp" for details

 
 #tcp_keepalives_idle = 0               # TCP_KEEPIDLE, in seconds;
                                        # 0 selects the system default
 
 #tcp_keepalives_idle = 0               # TCP_KEEPIDLE, in seconds;
                                        # 0 selects the system default

@@ -84,30 +98,35 @@ ssl = true
                                        # 0 selects the system default
 
 
                                        # 0 selects the system default
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # RESOURCE USAGE (except WAL)
 # RESOURCE USAGE (except WAL)

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Memory -
 
 
 # - Memory -
 

-shared_buffers = 1000                  # min 16 or max_connections*2, 8KB each
-#temp_buffers = 1000                   # min 100, 8KB each
+shared_buffers = 24MB                  # min 128kB or max_connections*16kB
+                                       # (change requires restart)
+#temp_buffers = 8MB                    # min 800kB

 #max_prepared_transactions = 5         # can be 0 or more
 #max_prepared_transactions = 5         # can be 0 or more

-# note: increasing max_prepared_transactions costs ~600 bytes of shared memory
+                                       # (change requires restart)
+# Note:  Increasing max_prepared_transactions costs ~600 bytes of shared memory

 # per transaction slot, plus lock space (see max_locks_per_transaction).
 # per transaction slot, plus lock space (see max_locks_per_transaction).

-#work_mem = 1024                       # min 64, size in KB
-#maintenance_work_mem = 16384          # min 1024, size in KB
-#max_stack_depth = 2048                        # min 100, size in KB
+#work_mem = 1MB                                # min 64kB
+#maintenance_work_mem = 16MB           # min 1MB
+#max_stack_depth = 2MB                 # min 100kB

 
 # - Free Space Map -
 
 
 # - Free Space Map -
 

-#max_fsm_pages = 20000                 # min max_fsm_relations*16, 6 bytes each
+max_fsm_pages = 153600                 # min max_fsm_relations*16, 6 bytes each
+                                       # (change requires restart)

 #max_fsm_relations = 1000              # min 100, ~70 bytes each
 #max_fsm_relations = 1000              # min 100, ~70 bytes each

+                                       # (change requires restart)

 
 # - Kernel Resource Usage -
 
 #max_files_per_process = 1000          # min 25
 
 # - Kernel Resource Usage -
 
 #max_files_per_process = 1000          # min 25

-#preload_libraries = ''
+                                       # (change requires restart)
+#shared_preload_libraries = ''         # (change requires restart)

 
 # - Cost-Based Vacuum Delay -
 
 
 # - Cost-Based Vacuum Delay -
 

@@ -115,24 +134,23 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
 #vacuum_cost_page_hit = 1              # 0-10000 credits
 #vacuum_cost_page_miss = 10            # 0-10000 credits
 #vacuum_cost_page_dirty = 20           # 0-10000 credits
 #vacuum_cost_page_hit = 1              # 0-10000 credits
 #vacuum_cost_page_miss = 10            # 0-10000 credits
 #vacuum_cost_page_dirty = 20           # 0-10000 credits

-#vacuum_cost_limit = 200               # 0-10000 credits
+#vacuum_cost_limit = 200               # 1-10000 credits

 
 

-# - Background writer -
+# - Background Writer -

 
 

-#bgwriter_delay = 200                  # 10-10000 milliseconds between rounds
-#bgwriter_lru_percent = 1.0            # 0-100% of LRU buffers scanned/round
-#bgwriter_lru_maxpages = 5             # 0-1000 buffers max written/round
-#bgwriter_all_percent = 0.333          # 0-100% of all buffers scanned/round
-#bgwriter_all_maxpages = 5             # 0-1000 buffers max written/round
+#bgwriter_delay = 200ms                        # 10-10000ms between rounds
+#bgwriter_lru_maxpages = 100           # 0-1000 max buffers written/round
+#bgwriter_lru_multiplier = 2.0         # 0-10.0 multipler on buffers scanned/round

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # WRITE AHEAD LOG
 # WRITE AHEAD LOG

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Settings -
 
 #fsync = on                            # turns forced synchronization on or off
 
 # - Settings -
 
 #fsync = on                            # turns forced synchronization on or off

+#synchronous_commit = on               # immediate fsync at commit

 #wal_sync_method = fsync               # the default is the first option 
                                        # supported by the operating system:
                                        #   open_datasync
 #wal_sync_method = fsync               # the default is the first option 
                                        # supported by the operating system:
                                        #   open_datasync

@@ -141,25 +159,32 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
                                        #   fsync_writethrough
                                        #   open_sync
 #full_page_writes = on                 # recover from partial page writes
                                        #   fsync_writethrough
                                        #   open_sync
 #full_page_writes = on                 # recover from partial page writes

-#wal_buffers = 8                       # min 4, 8KB each
+#wal_buffers = 64kB                    # min 32kB
+                                       # (change requires restart)
+#wal_writer_delay = 200ms              # 1-10000 milliseconds
+

 #commit_delay = 0                      # range 0-100000, in microseconds
 #commit_siblings = 5                   # range 1-1000
 
 # - Checkpoints -
 
 #checkpoint_segments = 3               # in logfile segments, min 1, 16MB each
 #commit_delay = 0                      # range 0-100000, in microseconds
 #commit_siblings = 5                   # range 1-1000
 
 # - Checkpoints -
 
 #checkpoint_segments = 3               # in logfile segments, min 1, 16MB each

-#checkpoint_timeout = 300              # range 30-3600, in seconds
-#checkpoint_warning = 30               # in seconds, 0 is off
+#checkpoint_timeout = 5min             # range 30s-1h
+#checkpoint_completion_target = 0.5    # checkpoint target duration, 0.0 - 1.0
+#checkpoint_warning = 30s              # 0 is off

 
 # - Archiving -
 
 
 # - Archiving -
 

-#archive_command = ''                  # command to use to archive a logfile 
-                                       # segment
+#archive_mode = off            # allows archiving to be done
+                               # (change requires restart)
+#archive_command = ''          # command to use to archive a logfile segment
+#archive_timeout = 0           # force a logfile segment switch after this
+                               # time; 0 is off

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # QUERY TUNING
 # QUERY TUNING

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Planner Method Configuration -
 
 
 # - Planner Method Configuration -
 

@@ -175,12 +200,12 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
 
 # - Planner Cost Constants -
 
 
 # - Planner Cost Constants -
 

-#effective_cache_size = 1000           # typically 8KB each
-#random_page_cost = 4                  # units are one sequential page fetch 
-                                       # cost
-#cpu_tuple_cost = 0.01                 # (same)
-#cpu_index_tuple_cost = 0.001          # (same)
-#cpu_operator_cost = 0.0025            # (same)
+#seq_page_cost = 1.0                   # measured on an arbitrary scale
+#random_page_cost = 4.0                        # same scale as above
+#cpu_tuple_cost = 0.01                 # same scale as above
+#cpu_index_tuple_cost = 0.005          # same scale as above
+#cpu_operator_cost = 0.0025            # same scale as above
+#effective_cache_size = 128MB

 
 # - Genetic Query Optimizer -
 
 
 # - Genetic Query Optimizer -
 

@@ -197,42 +222,44 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
 #constraint_exclusion = off
 #from_collapse_limit = 8
 #join_collapse_limit = 8               # 1 disables collapsing of explicit 
 #constraint_exclusion = off
 #from_collapse_limit = 8
 #join_collapse_limit = 8               # 1 disables collapsing of explicit 

-                                       # JOINs
+                                       # JOIN clauses

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # ERROR REPORTING AND LOGGING
 # ERROR REPORTING AND LOGGING

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Where to Log -
 
 
 # - Where to Log -
 

-#log_destination = 'stderr'            # Valid values are combinations of 
-                                       # stderr, syslog and eventlog, 
-                                       # depending on platform.
+#log_destination = 'stderr'            # Valid values are combinations of
+                                       # stderr, csvlog, syslog and eventlog,
+                                       # depending on platform.  csvlog
+                                       # requires logging_collector to be on.

 
 # This is used when logging to stderr:
 
 # 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
-                                       # Can be absolute or relative to PGDATA
-#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log' # Log file name pattern.
-                                       # Can include strftime() escapes
-#log_truncate_on_rotation = off # If on, any existing log file of the same 
-                                       # name as the new log file will be
-                                       # truncated rather than appended to. But
-                                       # such truncation only occurs on
+#logging_collector = off               # Enable capturing of stderr and csvlog
+                                       # into log files. Required to be on for
+                                       # csvlogs.
+                                       # (change requires restart)
+
+# These are only used if logging_collector is on:
+#log_directory = 'pg_log'              # directory where log files are written,
+                                       # can be absolute or relative to PGDATA
+#log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'       # log file name pattern,
+                                       # can include strftime() escapes
+#log_truncate_on_rotation = off                # If on, an existing log file of the
+                                       # same name as the new log file will be
+                                       # truncated rather than appended to.
+                                       # But such truncation only occurs on

                                        # time-driven rotation, not on restarts
                                        # time-driven rotation, not on restarts

-                                       # or size-driven rotation. Default is
+                                       # or size-driven rotation.  Default is

                                        # off, meaning append to existing files
                                        # in all cases.
                                        # off, meaning append to existing files
                                        # in all cases.

-#log_rotation_age = 1440               # Automatic rotation of logfiles will 
-                                       # happen after so many minutes.  0 to 
-                                       # disable.
-#log_rotation_size = 10240             # Automatic rotation of logfiles will 
-                                       # happen after so many kilobytes of log
-                                       # output.  0 to disable.
+#log_rotation_age = 1d                 # Automatic rotation of logfiles will
+                                       # happen after that time.  0 to disable.
+#log_rotation_size = 10MB              # Automatic rotation of logfiles will 
+                                       # happen after that much log output.
+                                       # 0 to disable.

 
 # These are relevant when logging to syslog:
 #syslog_facility = 'LOCAL0'
 
 # These are relevant when logging to syslog:
 #syslog_facility = 'LOCAL0'

@@ -241,7 +268,7 @@ shared_buffers = 1000                       # min 16 or max_connections*2, 8KB each
 
 # - When to Log -
 
 
 # - When to Log -
 

-#client_min_messages = notice          # Values, in order of decreasing detail:
+#client_min_messages = notice          # values in order of decreasing detail:

                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug5
                                        #   debug4
                                        #   debug3

@@ -252,7 +279,7 @@ shared_buffers = 1000                       # min 16 or max_connections*2, 8KB each
                                        #   warning
                                        #   error
 
                                        #   warning
                                        #   error
 

-#log_min_messages = notice             # Values, in order of decreasing detail:
+#log_min_messages = notice             # values in order of decreasing detail:

                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug5
                                        #   debug4
                                        #   debug3

@@ -268,7 +295,7 @@ shared_buffers = 1000                       # min 16 or max_connections*2, 8KB each
 
 #log_error_verbosity = default         # terse, default, or verbose messages
 
 
 #log_error_verbosity = default         # terse, default, or verbose messages
 

-#log_min_error_statement = panic       # Values in order of increasing severity:
+#log_min_error_statement = error       # values in order of decreasing detail:

                                        #   debug5
                                        #   debug4
                                        #   debug3
                                        #   debug5
                                        #   debug4
                                        #   debug3

@@ -278,13 +305,17 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
                                        #   notice
                                        #   warning
                                        #   error
                                        #   notice
                                        #   warning
                                        #   error

-                                       #   panic(off)
-                                
+                                       #   log
+                                       #   fatal
+                                       #   panic (effectively off)
+

 #log_min_duration_statement = -1       # -1 is disabled, 0 logs all statements
 #log_min_duration_statement = -1       # -1 is disabled, 0 logs all statements

-                                       # and their durations, in milliseconds.
+                                       # and their durations, > 0 logs only
+                                       # statements running at least this time.

 
 

-#silent_mode = off                     # DO NOT USE without syslog or 
-                                       # redirect_stderr
+#silent_mode = off                     # DO NOT USE without syslog or
+                                       # logging_collector
+                                       # (change requires restart)

 
 # - What to Log -
 
 
 # - What to Log -
 

@@ -292,33 +323,48 @@ shared_buffers = 1000                     # min 16 or max_connections*2, 8KB each
 #debug_print_rewritten = off
 #debug_print_plan = off
 #debug_pretty_print = off
 #debug_print_rewritten = off
 #debug_print_plan = off
 #debug_pretty_print = off

+#log_checkpoints = off

 #log_connections = off
 #log_disconnections = off
 #log_duration = off
 #log_connections = off
 #log_disconnections = off
 #log_duration = off

-log_line_prefix = '%t '                        # Special values:
+#log_hostname = off
+log_line_prefix = '%t '                        # special values:

                                        #   %u = user name
                                        #   %d = database name
                                        #   %r = remote host and port
                                        #   %h = remote host
                                        #   %u = user name
                                        #   %d = database name
                                        #   %r = remote host and port
                                        #   %h = remote host

-                                       #   %p = PID
-                                       #   %t = timestamp (no milliseconds)
+                                       #   %p = process ID
+                                       #   %t = timestamp without milliseconds

                                        #   %m = timestamp with milliseconds
                                        #   %i = command tag
                                        #   %m = timestamp with milliseconds
                                        #   %i = command tag

-                                       #   %c = session id
+                                       #   %c = session ID

                                        #   %l = session line number
                                        #   %s = session start timestamp
                                        #   %l = session line number
                                        #   %s = session start timestamp

-                                       #   %x = transaction id
-                                       #   %q = stop here in non-session 
+                                       #   %v = virtual transaction ID
+                                       #   %x = transaction ID (0 if none)
+                                       #   %q = stop here in non-session

                                        #        processes
                                        #   %% = '%'
                                        # e.g. '<%u%%%d> '
                                        #        processes
                                        #   %% = '%'
                                        # e.g. '<%u%%%d> '

-#log_statement = 'none'                        # none, mod, ddl, all
-#log_hostname = off
+#log_lock_waits = off                  # log lock waits >= deadlock_timeout
+#log_statement = 'none'                        # none, ddl, mod, all
+#log_temp_files = -1                   # log temporary files equal or larger
+                                       # than specified size;
+                                       # -1 disables, 0 logs all temp files
+#log_timezone = unknown                        # actually, defaults to TZ environment
+                                       # setting

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # RUNTIME STATISTICS
 # RUNTIME STATISTICS

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------
+
+# - Query/Index Statistics Collector -
+
+#track_activities = on
+#track_counts = on
+#update_process_title = on
+

 
 # - Statistics Monitoring -
 
 
 # - Statistics Monitoring -
 

@@ -327,105 +373,121 @@ log_line_prefix = '%t '                 # Special values:
 #log_executor_stats = off
 #log_statement_stats = off
 
 #log_executor_stats = off
 #log_statement_stats = off
 

-# - Query/Index Statistics Collector -
-
-#stats_start_collector = on
-#stats_command_string = off
-#stats_block_level = off
-stats_row_level = on
-#stats_reset_on_server_start = off
-

 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # AUTOVACUUM PARAMETERS
 # AUTOVACUUM PARAMETERS

-#---------------------------------------------------------------------------
-
-autovacuum = on                        # enable autovacuum subprocess?
-#autovacuum_naptime = 60               # time between autovacuum runs, in secs
-#autovacuum_vacuum_threshold = 1000    # min # of tuple updates before
-                                       # vacuum
-#autovacuum_analyze_threshold = 500    # min # of tuple updates before 
-                                       # analyze
-#autovacuum_vacuum_scale_factor = 0.4  # fraction of rel size before 
+#------------------------------------------------------------------------------
+
+#autovacuum = on                       # Enable autovacuum subprocess?  'on' 
+                                       # requires track_counts to also be on.
+#log_autovacuum_min_duration = -1      # -1 disables, 0 logs all actions and
+                                       # their durations, > 0 logs only
+                                       # actions running at least that time.
+#autovacuum_max_workers = 3            # max number of autovacuum subprocesses
+#autovacuum_naptime = 1min             # time between autovacuum runs
+#autovacuum_vacuum_threshold = 50      # min number of row updates before

                                        # vacuum
                                        # vacuum

-#autovacuum_analyze_scale_factor = 0.2 # fraction of rel size before 
+#autovacuum_analyze_threshold = 50     # min number of row updates before 

                                        # analyze
                                        # analyze

-#autovacuum_vacuum_cost_delay = -1     # default vacuum cost delay for 
-                                       # autovac, -1 means use 
+#autovacuum_vacuum_scale_factor = 0.2  # fraction of table size before vacuum
+#autovacuum_analyze_scale_factor = 0.1 # fraction of table size before analyze
+#autovacuum_freeze_max_age = 200000000 # maximum XID age before forced vacuum
+                                       # (change requires restart)
+#autovacuum_vacuum_cost_delay = 20     # default vacuum cost delay for
+                                       # autovacuum, -1 means use

                                        # vacuum_cost_delay
                                        # vacuum_cost_delay

-#autovacuum_vacuum_cost_limit = -1     # default vacuum cost limit for 
-                                       # autovac, -1 means use
+#autovacuum_vacuum_cost_limit = -1     # default vacuum cost limit for
+                                       # autovacuum, -1 means use

                                        # vacuum_cost_limit
 
 
                                        # vacuum_cost_limit
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # CLIENT CONNECTION DEFAULTS
 # CLIENT CONNECTION DEFAULTS

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 # - Statement Behavior -
 
 
 # - Statement Behavior -
 

-#search_path = '$user,public'          # schema names
-#default_tablespace = ''               # a tablespace name, '' uses
-                                       # the default
+#search_path = '"$user",public'                # schema names
+#default_tablespace = ''               # a tablespace name, '' uses the default
+#temp_tablespaces = ''                 # a list of tablespace names, '' uses
+                                       # only default tablespace

 #check_function_bodies = on
 #default_transaction_isolation = 'read committed'
 #default_transaction_read_only = off
 #check_function_bodies = on
 #default_transaction_isolation = 'read committed'
 #default_transaction_read_only = off

-#statement_timeout = 0                 # 0 is disabled, in milliseconds
+#session_replication_role = 'origin'
+#statement_timeout = 0                 # 0 is disabled
+#vacuum_freeze_min_age = 100000000
+#xmlbinary = 'base64'
+#xmloption = 'content'

 
 # - Locale and Formatting -
 
 
 # - Locale and Formatting -
 

-#datestyle = 'iso, mdy'
-#timezone = unknown                    # actually, defaults to TZ 
-                                       # environment setting
-#australian_timezones = off
+datestyle = 'iso, mdy'
+#timezone = unknown                    # actually, defaults to TZ environment
+                                       # setting
+#timezone_abbreviations = 'Default'     # Select the set of available time zone
+                                       # abbreviations.  Currently, there are
+                                       #   Default
+                                       #   Australia
+                                       #   India
+                                       # You can create your own file in
+                                       # share/timezonesets/.

 #extra_float_digits = 0                        # min -15, max 2
 #client_encoding = sql_ascii           # actually, defaults to database
                                        # encoding
 
 #extra_float_digits = 0                        # min -15, max 2
 #client_encoding = sql_ascii           # actually, defaults to database
                                        # encoding
 

-# These settings are initialized by initdb -- they might be changed
-lc_messages = 'C'                      # locale for system error message 
+# These settings are initialized by initdb, but they can be changed.
+lc_messages = 'C'                      # locale for system error message

                                        # strings
 lc_monetary = 'C'                      # locale for monetary formatting
 lc_numeric = 'C'                       # locale for number formatting
 lc_time = 'C'                          # locale for time formatting
 
                                        # strings
 lc_monetary = 'C'                      # locale for monetary formatting
 lc_numeric = 'C'                       # locale for number formatting
 lc_time = 'C'                          # locale for time formatting
 

+# default configuration for text search
+default_text_search_config = 'pg_catalog.english'
+

 # - Other Defaults -
 
 #explain_pretty_print = on
 #dynamic_library_path = '$libdir'
 # - Other Defaults -
 
 #explain_pretty_print = on
 #dynamic_library_path = '$libdir'

+#local_preload_libraries = ''

 
 
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # LOCK MANAGEMENT
 # LOCK MANAGEMENT

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 

-#deadlock_timeout = 1000               # in milliseconds
+#deadlock_timeout = 1s

 #max_locks_per_transaction = 64                # min 10
 #max_locks_per_transaction = 64                # min 10

-# note: each lock table slot uses ~220 bytes of shared memory, and there are
+                                       # (change requires restart)
+# 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.
 
 
 # max_locks_per_transaction * (max_connections + max_prepared_transactions)
 # lock table slots.
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # VERSION/PLATFORM COMPATIBILITY
 # VERSION/PLATFORM COMPATIBILITY

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 

-# - Previous Postgres Versions -
+# - Previous PostgreSQL Versions -

 
 #add_missing_from = off
 
 #add_missing_from = off

+#array_nulls = on

 #backslash_quote = safe_encoding       # on, off, or safe_encoding
 #default_with_oids = off
 #backslash_quote = safe_encoding       # on, off, or safe_encoding
 #default_with_oids = off

-#escape_string_warning = off
+#escape_string_warning = on

 #regex_flavor = advanced               # advanced, extended, or basic
 #sql_inheritance = on
 #regex_flavor = advanced               # advanced, extended, or basic
 #sql_inheritance = on

+#standard_conforming_strings = off
+#synchronize_seqscans = on

 
 

-# - Other Platforms & Clients -
+# - Other Platforms and Clients -

 
 #transform_null_equals = off
 
 
 
 #transform_null_equals = off
 
 

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 # CUSTOMIZED OPTIONS
 # CUSTOMIZED OPTIONS

-#---------------------------------------------------------------------------
+#------------------------------------------------------------------------------

 
 #custom_variable_classes = ''          # list of custom variable class names
 
 #custom_variable_classes = ''          # list of custom variable class names