0

I used this statement to change the postgres role permissions: 

ALTER ROLE postgres WITH NOLOGIN.

I have only one role: the postgres default role. Sorry for my stupidity. Now I can't login anyway to the DB. If I try to connect to the DB tha answer is:

C:\>psql -h 192.168.167.31 -U postgres
Inserisci la password per l'utente postgres:
psql: FATALE:  al ruolo "postgres" non è consentito effettuare il login
Improve this question
7
  • That's easy, see here. Commented Jun 27, 2019 at 6:43
  • If you upvote the answer there, I could mark this question as a duplicate. Commented Jun 27, 2019 at 9:17
  • Sorry i have a little more problem , on my pc i can't execute runas; it always says me the tha password or the username is incorrect; Commented Jun 27, 2019 at 9:28
  • I don't know enough about Windows for that. Why do you need runas? Commented Jun 27, 2019 at 9:43
  • I need runas to get postgres user from OS Commented Jun 27, 2019 at 9:59
Related questions
24
Can't log into PostgreSQL database
605
'password authentication failed for user "postgres"'
25
Login to PostgreSQL - Login failed
Load 7 more related questions Show fewer related questions

0

Reset to default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.