|
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. Regards, Alvaro Aguayo Operations Manager Open Comb Systems E.I.R.L. From: Pepe TD Vo <pepevo@xxxxxxxxx>
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? postgres=# create role appuser; ^CCancel request sent CREATE ROLE postgres=# ALTER ROLE appuser NOSUPERUSER; ^CCancel request sent ALTER ROLE postgres=# ALTER ROLE appuser NOREPLICATION; ^CCancel request sent ALTER ROLE postgres=# ALTER ROLE appuser NOCREATEROLE; ^CCancel request sent ALTER ROLE postgres=# ALTER ROLE appuser NOHERIT; ^CCancel request sent ALTER ROLE |
