RE: database lagging

Поиск
Список
Период
Сортировка
От Alvaro Aguayo
Тема RE: database lagging
Дата
Msg-id SC1P15201MB223815E976EE2CACECFC7572AFE59@SC1P15201MB2238.LAMP152.PROD.OUTLOOK.COM
обсуждение исходный текст
Ответ на database lagging  (Pepe TD Vo <pepevo@yahoo.com>)
Ответы Re: database lagging  (Pepe TD Vo <pepevo@yahoo.com>)
Re: database lagging  (Vijaykumar Jain <vijaykumarjain.github@gmail.com>)
Список 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@yahoo.com>
Sent: 23 July 2021 12:52
To: pgsql-admin@lists.postgresql.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

 

 

 

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

Предыдущее
От: Pepe TD Vo
Дата:
Сообщение: database lagging
Следующее
От: Scott Ribe
Дата:
Сообщение: Re: What's the dfifference between pg_start_backup+copy+pg_stop_backup+WAL vs. pg_start_backup+pg_stop_backup+copy+WAL?