Changes between Version 9 and Version 10 of PostgreSql


Ignore:
Timestamp:
09/23/09 11:40:20 (9 years ago)
Author:
joshuadf
Comment:

--

Legend:

Unmodified
Added
Removed
Modified
  • PostgreSql

    v9 v10  
    5050log_directory = 'pg_log'                # Directory where log files are written 
    5151log_filename = 'postgresql-%a.log'      # Log file name pattern. 
    52 log_truncate_on_rotation = on   # If on, any existing log file of the same 
    53 log_rotation_age = 1440                 # Automatic rotation of logfiles will 
    54 log_rotation_size = 0                   # Automatic rotation of logfiles will 
    55 lc_messages = 'en_US.UTF-8'                     # locale for system error message 
    56 lc_monetary = 'en_US.UTF-8'                     # locale for monetary formatting 
    57 lc_numeric = 'en_US.UTF-8'                      # locale for number formatting 
    58 lc_time = 'en_US.UTF-8'                         # locale for time formatting 
    59 log_statement = 'none'                  # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/ 
     52log_truncate_on_rotation = on           #  
     53log_rotation_age = 1440                 # Automatic rotation of logfiles  
     54log_rotation_size = 0                   #  
     55lc_messages = 'en_US.UTF-8'             # locale for system error message 
     56lc_monetary = 'en_US.UTF-8'             # locale for monetary formatting 
     57lc_numeric = 'en_US.UTF-8'              # locale for number formatting 
     58lc_time = 'en_US.UTF-8'                 # locale for time formatting 
     59log_statement = 'ddl'                   # none, mod, ddl, all; look in /var/lib/pgsql/data/pg_log/ 
     60stats_command_string = true             # allow "SELECT datname,current_query FROM pg_stat_activity" 
    6061EOF 
    6162cat >>/var/lib/pgsql/data/pg_hba.conf<<EOF 
     
    8788# template1=> \q 
    8889}}} 
     90 
     91== Query Logging == 
     92 
     93On RHEL5, edit `postgresql.conf` to include: 
     94{{{ 
     95log_statement = 'all' 
     96}}} 
     97Then restart the server and look at the logs in `/var/lib/pgsql/data/pg_log/`. 
    8998 
    9099== SSL Encryption ==