Changes between Version 9 and Version 10 of PostgreSql


Ignore:
Timestamp:
09/23/09 11:40:20 (10 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 ==