From: | Alvaro Aguayo <aaguayo(at)opensysperu(dot)com> |
---|---|
To: | Pepe TD Vo <pepevo(at)yahoo(dot)com>, "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | RE: database lagging |
Date: | 2021-07-23 18:07:08 |
Message-ID: | SC1P15201MB223815E976EE2CACECFC7572AFE59@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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(at)yahoo(dot)com>
Sent: 23 July 2021 12:52
To: pgsql-admin(at)lists(dot)postgresql(dot)org
Subject: database lagging
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
From | Date | Subject | |
---|---|---|---|
Next Message | Scott Ribe | 2021-07-23 18:07:47 | Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL? |
Previous Message | Pepe TD Vo | 2021-07-23 17:52:21 | database lagging |