On Fri, 23 Jul 2021 at 23:59, Vijaykumar Jain <vijaykumarjain.github@xxxxxxxxx> wrote:
On Fri, 23 Jul 2021 at 23:37, Alvaro Aguayo <aaguayo@xxxxxxxxxxxxxxx> 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?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
\du
select 1;
create table t(id int);
