I can run select query but lagging to create role, table,
Bach-Nga
No one in this world is pure and perfect. If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.
To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)
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?