Postgres Pro
Downloads
Home   >   mailing lists

database lagging - Mailing list pgsql-admin

From Pepe TD Vo
Subject database lagging
Date
Msg-id 1396983439.574027.1627062741652@mail.yahoo.com
Whole thread Raw
Responses RE: database lagging
Re: database lagging
Re: database lagging
List pgsql-admin
Tree view
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 by date:

Previous
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?
Next
From: Alvaro Aguayo
Date:
Subject: RE: database lagging