Re: database lagging

Hi,

On Fri, Jul 23, 2021 at 2:52 PM Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:

> 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
>
I would only expect such a behaviour when there is Synchronous Replication
enabled but the Standby is not reachable.
Check the parameters : synchronous_mode combined with
synchronous_standby_names.

>
> 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
>
>
>
>

--
Regards,
Avinash Vallarapu
CEO,
MigOps Inc.
Email: avi(at)migops(dot)com