lamiastella

psql: FATAL: Peer authentication failed for user "xnat01"

Sep 2nd, 2016
356
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.11 KB | None | 0 0
  1. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ sudo vi /etc/postgresql/9.4/main/pg_hba.conf
  2. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ sudo -i -u postgres
  3. postgres@klein:~$ psql
  4. psql (9.4.8)
  5. Type "help" for help.$ sudo vi /etc/postgresql/9.4/main/pg_hba.conf
  6.  
  7. postgres=# SELECT pg_reload_conf();
  8. postgres-# \q
  9. postgres@klein:~$ exit
  10. logout
  11. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ psql -d xnat -f sql/xnat.sql -U xnat01
  12. psql: FATAL: Peer authentication failed for user "xnat01"
  13. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ sudo -iu postgres psql -c "SELECT pg_reload_conf();"
  14. pg_reload_conf
  15. ----------------
  16. t
  17. (1 row)
  18.  
  19. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ psql -d xnat -f sql/xnat.sql -U xnat01
  20. psql: FATAL: Peer authentication failed for user "xnat01"
  21.  
  22.  
  23.  
  24. I have these in pg_hba.conf:
  25.  
  26. # Database administrative login by Unix domain socket
  27. local all postgres peer
  28.  
  29. # TYPE DATABASE USER ADDRESS METHOD
  30.  
  31. # "local" is for Unix domain socket connections only
  32. local all all peer
  33. # IPv4 local connections:
  34. host all all 127.0.0.1/32 md5
  35. # IPv6 local connections:
  36. host all all ::1/128 md5
  37.  
  38. local xnat xnat01 localhost trust
  39.  
  40.  
  41. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ vi /etc/postgresql/9.4/main/pg_hba.conf
  42. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ sudo vi /etc/postgresql/9.4/main/pg_hba.conf
  43. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ sudo -i -u postgres
  44. postgres@klein:~$ psql
  45. psql (9.4.8)
  46. Type "help" for help.
  47.  
  48. postgres=# SELECT pg_reload_conf();
  49. pg_reload_conf
  50. ----------------
  51. t
  52. (1 row)
  53.  
  54. postgres=# \q
  55. postgres@klein:~$ exit
  56. logout
  57. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ psql -d xnat -f sql/xnat.sql -U xnat01
  58. psql: FATAL: Peer authentication failed for user "xnat01"
Advertisement
Add Comment
Please, Sign In to add comment