SHARE
TWEET

db1.conf

Dyrcona Feb 18th, 2019 80 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # What IPs to listen on.
  2. listen_addresses = '192.168.1.73,172.16.0.122'
  3.  
  4. # Logging setup.
  5. log_destination = 'syslog'
  6. syslog_facility = 'LOCAL4'
  7. syslog_ident = 'postgres'
  8. log_min_duration_statement = 1000
  9. log_line_prefix = '%t [%p-%l] %q%u@%d '
  10.  
  11. # Optimizations
  12. huge_pages = on
  13. constraint_exclusion = on
  14. effective_cache_size = 576GB
  15. work_mem = 256MB
  16. maintenance_work_mem = 1536MB
  17. shared_buffers = 188GB
  18. random_page_cost = 1.5
  19. max_connections = 2000
  20. join_collapse_limit = 9
  21.  
  22. #wal settings
  23. wal_level = hot_standby
  24. wal_buffers = 8MB
  25. max_wal_size = 3072MB
  26. checkpoint_timeout = 30min
  27. checkpoint_completion_target = 0.9
  28. archive_mode = on
  29. archive_command = 'cp %p /usr/backups/database2/wal/%f'
  30. #archive_command = '/bin/true'
  31. max_wal_senders = 5
  32. hot_standby = on
  33. hot_standby_feedback = on
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top