Re: database lagging

Поиск
Список
Период
Сортировка
От Avinash Kumar
Тема Re: database lagging
Дата
Msg-id CAN0TujfnzsDRU=iK6pJFdMwMj6fGqpH7n2S+G8r_5kJ0S=7Mgg@mail.gmail.com
обсуждение исходный текст
Ответ на database lagging  (Pepe TD Vo <pepevo@yahoo.com>)
Ответы Re: database lagging  (Pepe TD Vo <pepevo@yahoo.com>)
Список pgsql-admin
Hi, 

On Fri, Jul 23, 2021 at 2:52 PM Pepe TD Vo <pepevo@yahoo.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.

В списке pgsql-admin по дате отправления:

Предыдущее
От: Rui DeSousa
Дата:
Сообщение: Re: database lagging
Следующее
От: Thorsten Schöning
Дата:
Сообщение: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?