Changes between Version 20 and Version 21 of PostgreSql


Ignore:
Timestamp:
03/02/12 10:17:56 (6 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