Guest User

Untitled

a guest
Jan 27th, 2018
151
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. data_directory = '/var/lib/postgresql/8.4/main'         # USE data in another directory
  2.                                         # (change requires restart)
  3. hba_file = '/etc/postgresql/8.4/main/pg_hba.conf'       # host-based authentication file
  4.                                         # (change requires restart)
  5. ident_file = '/etc/postgresql/8.4/main/pg_ident.conf'   # ident configuration file
  6.                                         # (change requires restart)
  7.  
  8. external_pid_file = '/var/run/postgresql/8.4-main.pid'          # WRITE an extra PID file
  9.                                         # (change requires restart)
  10.  
  11.  
  12. port = 5432                             # (change requires restart)
  13. max_connections = 384                   # Higher VALUE crashes (change requires restart)
  14.  
  15. unix_socket_directory = '/var/run/postgresql'
  16.  
  17. ssl = TRUE
  18.  
  19. shared_buffers = 24MB
  20.  
  21. log_line_prefix = '%t '
  22.  
  23. track_counts = ON
  24.  
  25. autovacuum = ON
  26.  
  27. autovacuum_naptime = 60min              # TIME between autovacuum runs
  28. autovacuum_vacuum_threshold = 5000      # min number OF ROW updates before
  29.                                         # vacuum
  30. autovacuum_analyze_threshold = 5000     # min number OF ROW updates before
  31.                                         # analyze
  32.  
  33.  
  34. lc_messages = 'en_GB'                   # locale FOR system ERROR MESSAGE
  35.                                         # strings
  36. lc_monetary = 'en_GB'                   # locale FOR monetary formatting
  37. lc_numeric = 'en_GB'                    # locale FOR number formatting
  38. lc_time = 'en_GB'                               # locale FOR TIME formatting
  39.  
  40. default_text_search_config = 'pg_catalog.english'
Add Comment
Please, Sign In to add comment