Is there any other thing running with that database? If so, I would consider a locking problem. CREATE/ALTER ROLE should never take too much time, unless there is some kind of lock in a global catalog.
I am not so sure this is lock issue? Ctrl C would not complete the command if it were a lock issue?
Pepe can confirm if he sees any locks though ?
Hey Pepe,
Can you let us know
what postgres version?
what psql version?
what OS?
also, is it possible for you to collect stack trace of the hanging process?
I am doing CIS Benchmart on Postgreql 12. After alter parameters and when I tried to create a new role. It's lagging and didn't prompt out the result, until I hit the ctl C key. Even alter role. All I needed to hit ctl C key if not, it hung there for ever. Is there a way to fix it?