Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.19 KB | None | 0 0
  1. 1 postgresql.conf + X
  2. hba_file = '/etc/postgresql/9.5/main/pg_hba.conf' # host-based authentication file
  3. # (change requires restart)
  4. ident_file = '/etc/postgresql/9.5/main/pg_ident.conf' # ident configuration file
  5. # (change requires restart)
  6.  
  7. # If external_pid_file is not explicitly set, no extra PID file is written.
  8. external_pid_file = '/var/run/postgresql/9.5-main.pid' # write an extra PID file
  9. # (change requires restart)
  10.  
  11.  
  12. #------------------------------------------------------------------------------
  13. # CONNECTIONS AND AUTHENTICATION
  14. #------------------------------------------------------------------------------
  15.  
  16. # - Connection Settings -
  17. listen_address = '*'
  18. #listen_addresses = 'localhost' # what IP address(es) to listen on;
  19. # comma-separated list of addresses;
  20. # defaults to 'localhost'; use '*' for all
  21. # (change requires restart)
  22. port = 5432 # (change requires restart)
  23. max_connections = 100 # (change requires restart)
  24. # Note: Increasing max_connections costs ~400 bytes of shared memory per
  25. # connection slot, plus lock space (see max_locks_per_transaction).
  26. #superuser_reserved_connections = 3 # (change requires restart)
  27. unix_socket_directories = '/var/run/postgresql' # comma-separated list of directories
  28. # (change requires restart)
  29. #unix_socket_group = '' # (change requires restart)
  30. #unix_socket_permissions = 0777 # begin with 0 to use octal notation
  31. # (change requires restart)
  32. #bonjour = off # advertise server via Bonjour
  33. # (change requires restart)
  34. #bonjour_name = '' # defaults to the computer name
  35. # (change requires restart)
  36.  
  37. # - Security and Authentication -
  38.  
  39. #authentication_timeout = 1min # 1s-600s
  40. ssl = true # (change requires restart)
  41. # (change requires restart)
  42. #ssl_prefer_server_ciphers = on # (change requires restart)
  43. #ssl_ecdh_curve = 'prime256v1' # (change requires restart)
  44. ssl_cert_file = '/etc/ssl/certs/ssl-cert-snakeoil.pem' # (change requires restart)
  45. ssl_key_file = '/etc/ssl/private/ssl-cert-snakeoil.key' # (change requires restart)
  46. #ssl_ca_file = '' # (change requires restart)
  47. #ssl_crl_file = '' # (change requires restart)
  48. #password_encryption = on
  49. #db_user_namespace = off
  50. #row_security = on
  51.  
  52. # GSSAPI using Kerberos
  53. #krb_server_keyfile = ''
  54. #krb_caseins_users = off
  55.  
  56. # - TCP Keepalives -
  57. # see "man 7 tcp" for details
  58.  
  59. #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds;
  60. # 0 selects the system default
  61. #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds;
  62. # 0 selects the system default
  63. #tcp_keepalives_count = 0 # TCP_KEEPCNT;
  64. # 0 selects the system default
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement