From: | Pepe TD Vo <pepevo(at)yahoo(dot)com> |
---|---|
To: | "pgsql-admin(at)lists(dot)postgresql(dot)org" <pgsql-admin(at)lists(dot)postgresql(dot)org> |
Subject: | database lagging |
Date: | 2021-07-23 17:52:21 |
Message-ID: | 1396983439.574027.1627062741652@mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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 sentCREATE ROLE
postgres=# ALTER ROLE appuser NOSUPERUSER;^CCancel request sentALTER ROLE
postgres=# ALTER ROLE appuser NOREPLICATION;^CCancel request sentALTER ROLE
postgres=# ALTER ROLE appuser NOCREATEROLE;^CCancel request sentALTER ROLE
postgres=# ALTER ROLE appuser NOHERIT;^CCancel request sentALTER ROLE
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Aguayo | 2021-07-23 18:07:08 | RE: database lagging |
Previous Message | Thorsten Schöning | 2021-07-23 17:44:35 | Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL? |