Re: database lagging

[Pepe TD Vo <pepevo@xxxxxxxxx>]

yes, I'm running replication database.  Parameters below are on both master and slave's postgresql.conf

wal_level = replica

synchronous_commit = on

synchronous_standby_names ='*'

server storage is fine.  Plenty of spaces on pg_wal (local), only 5% used from 80G.  Look like only all write have problems and read is ok.

Bach-Nga

No one in this world is pure and perfect.  If you avoid people for their mistakes you will be alone. So judge less, love, and forgive more.

To call him a dog hardly seems to do him justice though in as much as he had four legs, a tail, and barked, I admit he was, to all outward appearances. But to those who knew him well, he was a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deeply **Speak kindly.

*** Genuinely rich *** Faithful talent *** Sharing success

On Friday, July 23, 2021, 03:11:58 PM EDT, Avinash Kumar <avinash.vallarapu@xxxxxxxxx> wrote:

Hi, 

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