Guest User

Untitled

a guest
Oct 28th, 2017
87
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.94 KB | None | 0 0
  1. ## pg_hba.conf
  2. # TYPE DATABASE USER CIDR-ADDRESS METHOD
  3.  
  4. # "local" is for Unix domain socket connections only
  5. local all all md5
  6. # IPv4 local connections:
  7. host all all 127.0.0.1/32 md5
  8. # IPv6 local connections:
  9. host all all ::1/128 md5
  10.  
  11. ## command line works
  12. $ psql -U webapp -W template1 -h localhost
  13. Password for user webapp:
  14. psql (9.0.4)
  15. SSL connection (cipher: DHE-RSA-AES256-SHA, bits: 256)
  16. Type "help" for help.
  17.  
  18. template1=> \q
  19.  
  20. ## Why is the error for Ident authentication when the hostname is specified?
  21. $ cat config/database.yml
  22. development:
  23. adapter: postgresql
  24. encoding: utf8
  25. database: icecondor_development
  26. hostname: localhost
  27. username: webapp
  28. password: "thepassword"
  29.  
  30. $ script/dbconsole
  31. psql: FATAL: Ident authentication failed for user "webapp"
Add Comment
Please, Sign In to add comment