Changes between Version 20 and Version 21 of PostgreSql


Ignore:
Timestamp:
03/02/12 10:17:56 (8 years ago)
Author:
joshuadf
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PostgreSql

    v20 v21  
    4747# tested with Red Hat Enterprise Linux 6
    4848cat > postgresql.conf<<EOF
    49 lc_messages = 'en_US.UTF-8' # locale for system error message
    50 lc_monetary = 'en_US.UTF-8' # locale for monetary formatting
    51 lc_numeric = 'en_US.UTF-8' # locale for number formatting
    52 lc_time = 'en_US.UTF-8' # locale for time formatting
    53 listen_addresses = '*'
    54 log_directory = 'pg_log'
    55 log_filename = 'postgresql-%a.log' # log file name pattern,
    56 log_rotation_age = 1d # Automatic rotation of logfiles will
    57 log_rotation_size = 0 # Automatic rotation of logfiles will
    58 log_statement = 'ddl'                    # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/
    59 log_truncate_on_rotation = on # If on, an existing log file of the
    60 max_connections = 100 # (change requires restart)
    61 shared_buffers = 32MB # min 128kB
    62 logging_collector = on # Enable capturing of stderr and csvlog
     49# defaults   grep '^[a-z]' postgresql.conf.orig > postgresql.conf
    6350datestyle = 'iso, mdy'
    6451default_text_search_config = 'pg_catalog.english'
     52lc_messages = 'en_US.UTF-8'                     # locale for system error message
     53lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting
     54lc_numeric = 'en_US.UTF-8'                      # locale for number formatting
     55lc_time = 'en_US.UTF-8'                         # locale for time formatting
     56log_directory = 'pg_log'                # directory where log files are written,
     57log_filename = 'postgresql-%a.log'      # log file name pattern,
     58logging_collector = on                  # Enable capturing of stderr and csvlog
     59log_rotation_age = 1d                   # Automatic rotation of logfiles will
     60log_rotation_size = 0                   # Automatic rotation of logfiles will
     61log_truncate_on_rotation = on           # If on, an existing log file of the
     62max_connections = 100                   # (change requires restart)
     63shared_buffers = 32MB                   # min 128kB
     64# custom settings
     65listen_addresses = '*'
     66autovacuum = on
     67checkpoint_completion_target = 0.9
     68checkpoint_segments= 32
     69effective_cache_size = 1GB #1/2 your RAM
     70listen_addresses = '*'
     71log_statement = 'ddl'                    # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/
     72maintenance_work_mem= 256MB
     73random_page_cost = 3.0
     74wal_buffers = 16MB
    6575EOF
    66 cat >>/var/lib/pgsql/data/pg_hba.conf<<EOF
     76
     77cat >/var/lib/pgsql/data/pg_hba.conf<<EOF
    6778# TYPE  DATABASE        USER        IP-ADDRESS    IP-MASK           METHOD
     79local   all         all                               ident
    6880host    all         all         127.0.0.1/32          md5
    6981host    all         all         ::1/128               md5