lamiastella

xnat01 peer authentication failed

Sep 2nd, 2016
280
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.90 KB | None | 0 0
  1. postgres@klein:~$ psql
  2. psql (9.4.8)
  3. Type "help" for help.
  4.  
  5. postgres=# ALTER USER "xnat01" WITH PASSWORD "1234";
  6. ERROR: syntax error at or near ""1234""
  7. LINE 1: ALTER USER "xnat01" WITH PASSWORD "1234";
  8. ^
  9. postgres=# ALTER USER "xnat01" WITH PASSWORD '1234';
  10. ALTER ROLE
  11. postgres=# REVOKE CONNECT ON DATABASE xnat FROM PUBLIC;
  12. REVOKE
  13. postgres=# GRANT CONNECT ON DATABASE xnat FROM TO xnat01;
  14. ERROR: syntax error at or near "FROM"
  15. LINE 1: GRANT CONNECT ON DATABASE xnat FROM TO xnat01;
  16. ^
  17. postgres=# GRANT CONNECT ON DATABASE xnat TO xnat01;
  18. GRANT
  19. postgres=# GRANT ALL PRIVILEGES ON DATABASE xnat TO xnat01;
  20. GRANT
  21. postgres=# \q
  22. postgres@klein:~$ exit
  23. logout
  24. jalal@klein:~/computer_vision/XNAT/xnat/deployments/xnat/sql$ psql -d xnat -f sql/xnat.sql -U xnat01
  25. psql: FATAL: Peer authentication failed for user "xnat01"
Advertisement
Add Comment
Please, Sign In to add comment