Cannot login role into postgresql
2015-11-24 - How to fix a "Cannot login role" error on postgresql
Login is a permission on postgresql, that sometimes is not obvious it can cause issues.
Simply log in as postgres or another administrator account and run :
ALTER ROLE "user" LOGIN;