Open rubo77 opened 4 years ago
I found out, that the login string "some-username:localhost" is interpreted as port. correct would be "some-username@localhost", but now I get a new error:
a password was requested but not provided
sure, but my user has no password, I can login via psql --dbname=synapse
without password.
How can I login, if the user has no password?
I found out again: I have to create a user and grant access to it:
sudo -u postgres psql --dbname=synapse -c "create user newuser with encrypted password 'mypass';"
sudo -u postgres psql --dbname=synapse -c "grant all privileges on database synapse to newuser;"
But now I still get an error:
no authorization for relation "state_groups"
I get this error when calling