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.
From:
Thorsten Schöning Date: Subject:
Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?
Есть вопросы? Напишите нам!
Соглашаюсь с условиями обработки персональных данных
✖
By continuing to browse this website, you agree to the use of cookies. Go to Privacy Policy.