Re: database lagging

I'm running rh-postgresql12 psql version 12.5OS RHEL 7I 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)
**Live simply **Love generously **Care deeply **Speak kindly.*** Genuinely rich *** Faithful talent *** Sharing success

On Friday, July 23, 2021, 02:40:39 PM EDT, Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain <vijaykumarjain(dot)github(at)gmail(dot)com> wrote:

On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo(at)opensysperu(dot)com> wrote:

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 knowwhat postgres version?what psql version?what OS?
also, is it possible for you to collect stack trace of the hanging process?Getting a stack trace of a running PostgreSQL backend on Linux/BSD - PostgreSQL wiki

also is it only hanging in interactive mode? psql -c 'alter role foobar superuser;'   does this complete fine ?

also forgot to ask.does this only hang only alter role commands ?or any other command /query like \duselect 1;create table t(id int);