Changes between Version 20 and Version 21 of PostgreSql

Timestamp:

03/02/12 10:17:56 (8 years ago)

Author:

joshuadf

Comment:

--

PostgreSql

@@ -47 +47 @@
 # tested with Red Hat Enterprise Linux 6
 cat > postgresql.conf<<EOF
-lc_messages = 'en_US.UTF-8' # locale for system error message
-lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
-lc_numeric = 'en_US.UTF-8' # locale for number formatting
-lc_time = 'en_US.UTF-8' # locale for time formatting
-listen_addresses = '*'
-log_directory = 'pg_log'
-log_filename = 'postgresql-%a.log' # log file name pattern,
-log_rotation_age = 1d # Automatic rotation of logfiles will
-log_rotation_size = 0 # Automatic rotation of logfiles will
-log_statement = 'ddl'                    # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/
-log_truncate_on_rotation = on # If on, an existing log file of the
-max_connections = 100 # (change requires restart)
-shared_buffers = 32MB # min 128kB
-logging_collector = on # Enable capturing of stderr and csvlog
+# defaults   grep '^[a-z]' postgresql.conf.orig > postgresql.conf
 datestyle = 'iso, mdy'
 default_text_search_config = 'pg_catalog.english'
+lc_messages = 'en_US.UTF-8'                     # locale for system error message
+lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
+lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
+lc_time = 'en_US.UTF-8'                         # locale for time formatting
+log_directory = 'pg_log'                # directory where log files are written,
+log_filename = 'postgresql-%a.log'      # log file name pattern,
+logging_collector = on                  # Enable capturing of stderr and csvlog
+log_rotation_age = 1d                   # Automatic rotation of logfiles will
+log_rotation_size = 0                   # Automatic rotation of logfiles will 
+log_truncate_on_rotation = on           # If on, an existing log file of the
+max_connections = 100                   # (change requires restart)
+shared_buffers = 32MB                   # min 128kB
+# custom settings
+listen_addresses = '*'
+autovacuum = on
+checkpoint_completion_target = 0.9
+checkpoint_segments= 32
+effective_cache_size = 1GB #1/2 your RAM
+listen_addresses = '*'
+log_statement = 'ddl'                    # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/
+maintenance_work_mem= 256MB
+random_page_cost = 3.0
+wal_buffers = 16MB
 EOF
-cat >>/var/lib/pgsql/data/pg_hba.conf<<EOF
+
+cat >/var/lib/pgsql/data/pg_hba.conf<<EOF
 # TYPE  DATABASE        USER        IP-ADDRESS    IP-MASK           METHOD
+local   all         all                               ident
 host    all         all         127.0.0.1/32          md5
 host    all         all         ::1/128               md5