Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70qW-0000lS-Vr for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 19:28:33 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m70qV-0000hC-PF for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 19:28:31 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m70qV-0000h4-Eh for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 19:28:31 +0000 Received: from sonic313-9.consmr.mail.ne1.yahoo.com ([66.163.185.32]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m70qR-0005Rw-TO for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 19:28:31 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627068504; bh=R8rXhtp8RsVoIGVXmiF+SWHMgJMRUIEOwMoecTv3uwA=; h=Date:From:Reply-To:To:Cc:In-Reply-To:References:Subject:From:Subject:Reply-To; b=YWXC1J/ScPYcCzkNnA3BsUG83ZpPjhbHDy9IXI1W0bvtOymMGDZhMqJmSA8hjGtE+60GS9JZy7Li9SALHGKDRYBXJNoeauzYjeG3/8QGLo4d+GGZt5t08NQw1JGKmHcfQ4aL1ETFXxQx+t9m2z5/HI3JiZIeZz/0c8b7WHInbAJeb1/SUguA7M1uLC5ntqXkvWYWXM0eB8A8JE3cWccAzwQMFGelIObgI7j7uu3Y0tMSuK6tZdsPnKAMF9H3Q1ZmiSDYBRPvEujXAoLf6zLL3IG3pHHQDz+V6+GQ82FKY6YNDHg/uoahApJBFkxrOPG88wNZGYmaTzv9q8NJsn+whw== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627068504; bh=yhwcz4McIUNtWxdBXacGJXq1zWLpRX6mbjgOsURqI+D=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=rujDRm0kjbCyfJhn3N/1mr+I/aShNTGQorhGdSKvJM+JvlZRObVEjjLq1O2Aj9X5AymJtXU8DZ8c9+FqggHYtAttf2jGxrBdyoVXVxz2x5JXZKk1dHPDm8zAxQ13ZpMPn1ve5XTVOnw6DclpUPdSy5jOslDzk2bP8Z6XyUdl68G2jHDQns9eLYMkVRR3nx4w5PDrF6zg0h/X9FH83J5sc6pC7S+f11Z37kUf3YRcYmf9P/puP55QzJKJsMsQBkqZIoelPKYY5YB/Ebdr+NZbvArAKXZP4/WEg3QkX6W7jR6TLuT2umrXB4zxInhYc0jUMxik8ml1+kUA3SBBMto6Vw== X-YMail-OSG: 63Fu20UVM1n8s86bdQd3Cvs_mNHWLG.SWGXAEEfnaRQX4fYZkNqrJpK8BUAFUe_ DseStTLxZXmBt.jQHhN4uIaZo9SLwziEjG6GC.7zNQrGKsXz0FBPYhEFe1ZwedM5vdQT5ARMjq2v WbAua3sJ7iRAD9U9qGWNOwpqgqxe6qq6v9k8iWdn.KKqfUPJgFFwWD7Qncktz0XtsFCwxxy7y.zb 0Wx.rBvj.hqNpMTu8n_MUsMk1FbFUGzYL1QiJGOJLFWiwefNkymfxkY0bTKsQ3GpEsaBCjp4Or2S 1l9r7G_hEJi6bm8EbHgpIzB5wBFy5Tv.10wt04RWz9K86XAT1gsmOUKZl7rshGeBlFAw6r2dEN0c Jcn2.R8M9vH2vy9O7.B37dGhJPu9hadRXQXy3Bx3zGVCReiopAvZgEZbUyIipXZR9WY90wkrYe6c r6VnI3zLhL7OtmC0kp_NhyvnvMurj3coDnrkDEmQPmYmuuzJ3W7.xZuMulfxcfoHyheDiNcOhiJX vh1z2nPhpOLvfovB5QjOrXlY.7G3Nv2nJDWn0uad8ujV2yKLOf3xFcfD87GcOWfL19lwZMqjXNCu T6PlsHJdtIN9FSuI7E4xKEGTeSyv0lXSzISidUe68CgmP6XaX2xpkE3Co9yBY_ZPYUtihkgqWLxE cysrxE_TJof0Vhjxl8ub31EzgPkLJoB1XidHa2GHcuNrD1Y6J4eRMviPFs2RAYTKUr6TveH4ED_i Xlh2W4jZY8vi7C4Cy3s88K7hsjEbdWqcoOg6J3J5ivhVkufX_c8YhlBSAv6La.HfszvaB9T7wIYx XEn5_3Gam32k7kHQCExx.1tWbh.hnk9Kq9CyKm3.Ieb1PVtvEIqlOy4ye1LxlbbiWUatTaogL9hv Xah5I.fILNQLy38O_kPMQ_2awUO92tdgJMBDZv3GP1Dpd7OWiqGQLrGsWs9sTQ5frOeub8ujqCIX cSE_mk_Q_qmN0Vcgn3j3qA02q9eFkpzj2axYWsKZvpUdDDHHY2nxU5q7Lzrf_fgz8yjakaZvSptH 82exSIC1rAFUtPhvv0TTlaQ_zMQT_JCHgZMYTLOdqMFXjE3HchlhvvyyKu7I4XN65TUb9P0l5GRu Y.BQy_DRn_ZbWiSjPZtJkzshmVeog6wX0alBDTgWj.qjmtiC95EGiRGx8aVR4EuRrI18IsXnbgQ7 4vkTK6infkwQX5kCE1X8Rv1kNihOxqAAyz8k0Xrta8XRBleFnXC4Vb5nYHZRPcJEGHUdR_ObPrDT w1zMimF4JQHZW8PWOSmAkH0bdyOEMJ.sM8Odn0QHxr39rH68flytomS9BgGbA9FS4.ozzft.5s1w cX7gLXqO3tirEGRdU7IgQRjjngw03xm5sJvM48exLFmwJ4TddFnjGJZionXq4EHeBhSNhOfMnjJN l1i.o6by3ufYIEppA8eRxJpP5HAyRurPOx05AprzC9v9tNWqHEWTUTg9mRFso.5EH092R4CgweWP OwOeFuGF73PooJHvOpWqX20pTBg.rshJbqgBJT8SD_PWNEXuzdiPBElcwUhBLL6uoL3q.XFd3rio 3DTGfi0BOFxTmVkwGcIQAcIMGHB3iA.81tZgmiltcUFmX7tZRYRhgWP8PMbM_.VZ8yPcPlPhRnl2 tp9CP..vgGgKSc_3UtlJximtj1p88XlivFCmfn6JhCEgvo4k_dXkiqjMmB5cSBN4LGGu8WuAfpBX E.vH6rjkcH2p7ZPMfv9aANTayfVivwHRERrFGQN4r7ZFIvABMtUYYKH3ISkHJDEVf9xg_y.8RODh 9y7E6_Ttnbkyd9dfUeV5FkI4rwSbg9H6AdW7dAICK16cOvel9ebr.V6tpsSaPQmY29V89twDU0BU Mr8N2MekHS2x6sZNP_n.RP9sOc3TUqYF9bC9KkairfB.eFXvqzzsgiyUICBJh9c27wk__ltF5aQE ZMsRTbXkIsZaRhIf8UPjGrGWIGD8uSMe8Ot_hvDPD20HeDkXBO0smNIgKPS1n9OMKhdFNwrWsAIP mMFDY5vh6sBhTwalqlvGPoxnJTA.HhHqF80UjjxD6ZzRQVCjW1RdGbwEK1clDAx.sjYtQ87EQdVk eD6Q2oAHGu3.SUmyiPLKNXrwIWw_xO_V7vXcGeKlWSt5GpoxnBGBZix_.CKX4VipTWYOeHQ.QpNz OxYI94deMDcCybmi36933f.ucqveVllvdcceItFt0YbW8iSHVKB0XCpU0A_KADpzRfQYRB6Mjh_Q IfJzAWuzLhGmrwzK5QROnCxqx.oIj4Yirew6Fmojha7A3wqQLTcdzEKtiF.d8LfHUB6ap7sWOVVJ CHPKqcahhlHirZCJwSsxvx5Nlektg.v4ftXKgObx7T7ztIjqzQ7yraXocCsDa1eQgCXi7L9ZM5jm tf.rY4ukUV.v_XWF87XSPsNbwn.m1s37gxjAqBuyGpHUvaXIZKNiYxxX2Zit3wjPXY_xd7yi.GXR 83FZQgKOZeoREvJ2bmpnw_UETKYUhuj5UK7fVXOsc3.H8JswS2psDs4oE1CmWwqq4w4HtOqW_0uS MGaJoq7jKYlPW7eky22LNujSoTsE9SDkZbA67NqYsu0nngaM- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic313.consmr.mail.ne1.yahoo.com with HTTP; Fri, 23 Jul 2021 19:28:24 +0000 Date: Fri, 23 Jul 2021 19:28:23 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: Avinash Kumar Cc: "pgsql-admin@lists.postgresql.org" Message-ID: <2031576315.606187.1627068503597@mail.yahoo.com> In-Reply-To: References: <1396983439.574027.1627062741652.ref@mail.yahoo.com> <1396983439.574027.1627062741652@mail.yahoo.com> Subject: Re: database lagging MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_606186_1875726741.1627068503594" X-Mailer: WebService/1.1.18736 YMailNorrin Content-Length: 12798 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_606186_1875726741.1627068503594 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable yes, I'm running replication database.=C2=A0 Parameters below are on both m= aster and slave's postgresql.conf wal_level =3D replicasynchronous_commit =3D onsynchronous_standby_names =3D= '*' server storage is fine.=C2=A0 Plenty of spaces on pg_wal (local), only 5% u= sed from 80G.=C2=A0 Look like only all write have problems and read is ok. Bach-Nga No one in this world is pure and perfect.=C2=A0 If you avoid people for the= ir mistakes you will be alone. So judge less, love, and forgive more.To cal= l 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 =20 On Friday, July 23, 2021, 03:11:58 PM EDT, Avinash Kumar wrote: =20 =20 Hi,=C2=A0 On Fri, Jul 23, 2021 at 2:52 PM Pepe TD Vo wrote: I am doing CIS Benchmart on Postgreql 12.=C2=A0 After alter parameters and = when I tried to create a new role.=C2=A0 It's lagging and didn't prompt out= the result, until I hit the ctl C key.=C2=A0 Even alter role.=C2=A0 All I = needed to hit ctl C key if not, it hung there for ever.=C2=A0 Is there a wa= y to fix it? postgres=3D# create role appuser;^CCancel request sentCREATE ROLE I would only expect such a behaviour when there is Synchronous Replication = enabled but the Standby is not reachable.=C2=A0 Check the parameters : synchronous_mode combined with synchronous_standby_n= ames.=C2=A0 postgres=3D# ALTER ROLE appuser NOSUPERUSER;^CCancel request sentALTER ROLE =C2=A0postgres=3D# ALTER ROLE appuser NOREPLICATION;^CCancel request sentAL= TER ROLE postgres=3D# ALTER ROLE appuser NOCREATEROLE;^CCancel request sentALTER ROL= E postgres=3D# ALTER ROLE appuser NOHERIT;^CCancel request sentALTER ROLE --=20 Regards, Avinash VallarapuCEO,MigOps Inc.Email: avi@migops.com =20 ------=_Part_606186_1875726741.1627068503594 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
yes, I'm running replication database= .  Parameters below are on both master and slave's postgresql.conf

wal_le= vel =3D replica
synchronous_commit =3D on
synchronous_standby_names =3D'*'

server stor= age is fine.  Plenty of spaces on pg_wal (local), only 5% used from 80= G.  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.3D"Emoji"3D"Emoji"3D"Emoji"
To call him a dog hardly seems to do him justice th= ough 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)

<= span style=3D"color:rgb(128, 0, 255);" id=3D"ydpf8dd9bc5yui_3_13_0_rc_1_1_1= 381789421038_7867">**Live simply **Love generously **Care deeply **Speak ki= ndly.
*** Genuinely rich *** Faithful talen= t *** Sharing success




=20
=20
On Friday, July 23, 2021, 03:11:58 PM EDT, Avinash Kuma= r <avinash.vallarapu@gmail.com> wrote:


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 an= d when I tried to create a new role.  It's lagging and didn't prompt o= ut 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=3D# create role appuser;
^CCancel reques= t sent
CREATE ROLE
I would only expect such a behaviour when there is Synchronous Replication= enabled but the Standby is not reachable. 
Check th= e parameters : synchronous_mode combined with synchronous_standby_names.&nb= sp;

postgres= =3D# ALTER ROLE appuser NOSUPERUSER;
^CCancel request se= nt
ALTER ROLE

=
 
postgres=3D# ALTER ROLE appuser NOR= EPLICATION;
^CCancel request sent
ALT= ER ROLE

postgres=3D# ALTER ROLE appuser NOCREATEROLE;
^CCancel request sent
ALTER ROLE

postgres=3D# ALTER = ROLE appuser NOHERIT;
^CCancel request sent
ALTER ROLE

<= br clear=3D"none">

=


--=
Regards,
Avinash Vallarapu
CEO,
MigOps Inc.
------=_Part_606186_1875726741.1627068503594--