LordSputnik

pg_hba.conf

Aug 27th, 2014
351
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.19 KB | None | 0 0
  1. # authentication methods -- refer to the "Client Authentication"
  2. # section in the documentation for a list of which options are
  3. # available for which authentication methods.
  4. #
  5. # Database and user names containing spaces, commas, quotes and other
  6. # special characters must be quoted. Quoting one of the keywords
  7. # "all", "sameuser", "samerole" or "replication" makes the name lose
  8. # its special character, and just match a database or username with
  9. # that name.
  10. #
  11. # This file is read on server startup and when the postmaster receives
  12. # a SIGHUP signal. If you edit the file on a running system, you have
  13. # to SIGHUP the postmaster for the changes to take effect. You can
  14. # use "pg_ctl reload" to do that.
  15.  
  16. # Put your actual configuration here
  17. # ----------------------------------
  18. #
  19. # If you want to allow non-local connections, you need to add more
  20. # "host" records. In that case you will also need to make PostgreSQL
  21. # listen on a non-local interface via the listen_addresses
  22. # configuration parameter, or via the -i or -h command line switches.
  23.  
  24. local all all trust
  25.  
  26.  
  27.  
  28. # DO NOT DISABLE!
  29. # If you change this first entry you will need to make sure that the
  30. # database superuser can access the database using some other method.
  31. # Noninteractive access to all databases is required during automatic
  32. # maintenance (custom daily cronjobs, replication, and similar tasks).
  33. #
  34. # Database administrative login by Unix domain socket
  35. local all postgres peer
  36.  
  37. # TYPE DATABASE USER ADDRESS METHOD
  38.  
  39. # "local" is for Unix domain socket connections only
  40. local all all peer
  41. # IPv4 local connections:
  42. host all all 127.0.0.1/32 md5
  43. # IPv6 local connections:
  44. host all all ::1/128 md5
  45. # Allow replication connections from localhost, by a user with the
  46. # replication privilege.
  47. #local replication postgres peer
  48. #host replication postgres 127.0.0.1/32 md5
  49. #host replication postgres ::1/128 md5
Advertisement
Add Comment
Please, Sign In to add comment