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 1m6ztD-00072r-8Y for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 18:27:15 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1m6ztC-0005Al-2z for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 18:27:14 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1m6ztB-00059Z-A6 for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 18:27:13 +0000 Received: from sonic306-21.consmr.mail.ne1.yahoo.com ([66.163.189.83]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6zt6-0004SS-Kn for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 18:27:12 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627064826; bh=B6J3RKTZxcl23+y2HlkQf0feqtX7wLweaAdL60qjo+o=; h=Date:From:Reply-To:To:In-Reply-To:References:Subject:From:Subject:Reply-To; b=qaqDThW+uHS5Nt91AgVjWvzKv0A6DRRMPtoqaZKGtO0Z0STnRXY/ZogYoa+FcD72bB8IXy/OZ+jUPhjWgt9qO3ZxXbpBwlU5o75KsOQ6C3on4s3iVderMrBu+vmLpNRsGtzlZbG92/D8K8A06SxWjSUZtvlgYgSn3THaynz3omPjfE2ZyghiHFZCeHC0vMMsHhroQD90Y/GfIVoQVgDF/MXi26lBikfsPkUg7+3sNfEerxF3Uet0NOpZCOrfAZ8aiGbEjWypZGpG2NyvYE0i8meX+il7ob3/kxws/RR5mB33qm2a8RSMD5loiE07pA/QZKlP5yVxAmLkV7AjgInPrg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627064826; bh=CVLAA4ZTsxIA/Okiu8KFZ7lHob7qZtmJ8eXbUlnZyB/=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=N9iuq8lOvszRDUY+U6cW3gPrV6qMr0DOPVemjgb95qdFK3AK8E47m6HoGogQQHGB2NJJ9Dq4GXtYuDrRmi2NbiwwV+2JEXOQIfv6GtbV971lPgpPEyRdX4f5mKRmRCY8M3lpt3/7EiWXthtp+TQfeQ+agGU7gtlEzwGQVg09+IRhDhIW7NGh7yL3AkzZhjdkmeqRcBj3uLKrGuQjjTvSz2pjT2eHNP4ougM+qA0/FypQB5sh8SYQl2U7DTp+A2IFHZw5zW5RB1HW6r/tekhrUReHwO1cJpZeaI3jbei4dLysDdAYtdkKH4iisbH87QsNt69VutR/yqRvgLEESWIr/g== X-YMail-OSG: NXljBN4VM1nUuXzuWsiMR0IX_rhYGwPvuOAQQal3CmxaQFv.YifEtyjVy2iHA2_ DUchxUP3p1_0U9xmWExzd7zPauBRX7N43pK.cgQaQrMe1MExQmzYlc.r4NTsrjxL42D5bmHDoAv8 CB8RyDc5.JIZtss.pGWyviPxEmYfOT1lFhERDvHzBXpN0iKglTTDAVjT8sAFuhJC3H.GQ10LdIdC Jkh8eZwtjJ14Hg2Lthd4TZqyD95kGHqi5SD29yMpSN5PVlrq6EhfMfb14.egGYf59UF6zIeuFIjg c9H7yrzZ7HNWwM6QkDD69iKTRdDeAHAr_TZ89NBVnuM3Opd0ERDMaY2mRnOonV1aKEzLBcj1aaYk kRYLA7S7Yt7hAYOwrgLYT2JQfes8yi_CZLzz.19.R1QunAeZ4YeykgfZ4oCLj7LYhvabaL4yyzt8 MgKqzd6zULf.ksnEQb0MZZS8lq5I6DnfZ3WS9eQHFwlURgAK7XeEZfYIr4lF0fCp5OAz4P_tISd1 vSzr8CjSwtzGxApCx5N9Yk_MIxV2suQQOzSfmmG6CTa5cvtcuLSYUw0QfceesFnWJ6mbRmNxr_Oe _2YK.Mt3wFSjVo5wp64frYFIib8qNI.0phzKrt74DBQyTR3IvxU_4AZp8wnp6Q5mHEZ.ncWDbADV rT3xZ0ZTx4YS2_cuKNIYd_SSKfdh8AwWXJPVDvNms3jab8IhXBQwlZD5TUIwROne43_xfwj4z_FG QNZ6SzXLuSDsRCNmHstTIB9nOiOGZ57JHw4XB.yvwqhotJFgdCaRLdTLcsJCRI4PpEmR1c1wFLIB Zq80laGs0KLGfFd.3Z8blOdRbVOIWOfJYIl0EoI7f6PVjm.v_Nzg10M6dxl3_hEMNuo9elTGGtUr bbJ217ERTjuiiK9ah67xT7Q39FJsk7YpHStIcyKMRymReQnsVdc616sK8LSiT8rU98zMX9CuhDzl Obt46yeZPzC1mAVulspWi0236Kp1Gl2sPcKDNifkFa7.pR2gma8Cu_TBmEAZL97v5YP.PLAwfFZw hfXfle4XEai1spez560A10EVuD84TkU6OmB0AHc3koPzP4alPKfOGxYwE.FbkE1mYapOM0dOwx1a N_bypzLsHkBI6KE516fsZMqQ4H0LOZbLp8LNluiZ8xOkL3IfKCq1bWtcwanConPifEvzt.SIilmk ZHDiXmjtqDS_yaYjcoEsKF0S7q74gMemrOfLvKoSGoZR2hipnrXfreRpFrIiTW2lIMY5907m2RY6 YFQ10QrKdX1zCWim7Bf.QDkCeEV8_JyD8F3BYbez8_BLdDVsRNDN3w8gvgc0JQX4Us.VPsVAeg98 1pHUZQdNkdnliSHy_VvvE3jjMbiqN8qjlR20nxtpvFJg2G0spW1ELUC9aYq5GzfCUG6zB.7YW7r_ e3Yt1zVUeZS_PW1fyx8dIMxZjMm_NGojqteVcSws9c6RBwpz3SwMmxBcLLzr.IYesutSh4R10VaL 3gahsqC9X76qf9h0R3rGpJQ.KZ5aAINstO.In3.5EFJJn.o9359daJodYaehxJJYD5WS.8DENSxE 9YOIsebzH4Qlm59Lq_sDOMdzsUyeGd5_O2FE4sWwYdLLZxmgspWIWYIwaTKCkuQkWkfLNIxgJeLE zfQEj79nI4ENArzMAsQk7D4y.PhFsSM5G_nxio5VSVZC9J5VZpImIgMumyU5z5oX9heVLoIITgJL 3w.GjAyHkwrHS1pTuWgnypBxt.s9caDmWg4T_vqkIFrsZvYWDkhBNY6wrykKEYzbeHYx1hk55Fyz HAeiKdhJdWjVyZGiBk.sxAIHhdrSYKNJy97nDtr6JjOtUP_0WNxa.QQ1hVrwi2jnLCtrroTY5s1Q viu7Buhy.izX9RwZY6keZinCCjEvV21mLy.siOMYp4UlMkVtqGM4Sk58WcXRMxUIrd3nOR2fVOt2 fp6vcaneME0w0IH9JR11fS3BZd9CYCisYdGZVmORlGCe3hRs6x5FzH70uj51O_4txAspJEKFusk9 WMAT0zuaYvnIlspM0ZllDd8ZwWbpNs5ziUpTQIVkGpjjZDomAxfN0oTa1XqofP3rDfESGHQIfWVk x66l5DsSwj_vKoXWgvBRKKABdhLm5hKZBMQHgtXV2tjnlmyYQ6MQtmR6xjld7_WRnUehQkn4h2uh NYdV.FOAs_8xQzE9YuyEhsmtr1raQX7.QDnDsT8hhMpUGYhJRFIBtc.kt_zJD7nihNdSnQOOjg1R 4ysBkJIIIkCAEj3VtH_G7J6MvXv9NjpE0sc0Ey7SMpQ.UgeUWVKbeqxnIatv.ZI2EqGUZ3d2dYDI SUDXMeN.RuCwKj9sxub5jJbKI4EFszDMHEbRxrzcgBxvGrA8dpyKs2u8LQXJTOdxV_9_wBWpBCb1 rpLNFUGpwI3htGN_1Zx_a3tUHJWMNtrtCYWOezAybcqZtqJ9pEPtU8EvTYKxsftZ1gIPKBGvjcfT VZMMZQ.BftgS73CurURw7gXalZEBZbSUqzHSJZTmUyO7Ka_fP_oBEL6N3fz2EW2eaxh_kk7CfQ1p v5oxNqyOP7VDYpo_Nsp_JE7cX1HHWcw.fh0HptJql X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic306.consmr.mail.ne1.yahoo.com with HTTP; Fri, 23 Jul 2021 18:27:06 +0000 Date: Fri, 23 Jul 2021 18:27:01 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@lists.postgresql.org" , Alvaro Aguayo Message-ID: <678607417.590943.1627064821704@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_590942_827424099.1627064821701" X-Mailer: WebService/1.1.18736 YMailNorrin Content-Length: 15475 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_590942_827424099.1627064821701 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable nothing is running. Only psql and background writer, checkpointermain, walw= ritermain, autovacuummain, logicalLauncherMain from pg_stat_activity (6 row= s) nothing else is running no row select on "select relation::regclass, * from pg_locks where not gran= ted; select on "select relation::regclass, * from pg_locks; 2 rows for pg_locks relation for AccessShareLock and virtualxid for Exclusi= veLock. What else can I check and correct ? 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, 02:07:15 PM EDT, Alvaro Aguayo wrote: =20 =20 Is there any other thing running with that database? If so, I would conside= r a locking problem. CREATE/ALTER ROLE should never take too much time, unl= ess there is some kind of lock in a global catalog. =20 =C2=A0 =20 Regards, =20 =C2=A0 =20 Alvaro Aguayo =20 Operations Manager =20 Open Comb Systems E.I.R.L. =20 =C2=A0 =20 From: Pepe TD Vo Sent: 23 July 2021 12:52 To: pgsql-admin@lists.postgresql.org Subject: database lagging =20 =C2=A0 =20 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? =20 =C2=A0 =20 postgres=3D# create role appuser; =20 ^CCancel request sent =20 CREATE ROLE =20 =C2=A0 =20 postgres=3D# ALTER ROLE appuser NOSUPERUSER; =20 ^CCancel request sent =20 ALTER ROLE =20 =C2=A0 =20 =C2=A0 =20 postgres=3D# ALTER ROLE appuser NOREPLICATION; =20 ^CCancel request sent =20 ALTER ROLE =20 =C2=A0 =20 postgres=3D# ALTER ROLE appuser NOCREATEROLE; =20 ^CCancel request sent =20 ALTER ROLE =20 =C2=A0 =20 postgres=3D# ALTER ROLE appuser NOHERIT; =20 ^CCancel request sent =20 ALTER ROLE =20 =C2=A0 =20 =C2=A0 =20 =C2=A0 =20 ------=_Part_590942_827424099.1627064821701 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
nothing is running. Only psql and= background writer, checkpointermain, walwritermain, autovacuummain, logica= lLauncherMain from pg_stat_activity (6 rows) nothing else is running
<= div dir=3D"ltr" data-setdir=3D"false">
no row select on "select relation::regclass, * from pg_locks wh= ere not granted;

s= elect on "select relation::regclass, * from pg_locks;
2 rows for pg_locks relation for AccessShareLock and virtualxid for Ex= clusiveLock.

What else can= I check and correct ?





<= /font>
Bach-Nga

No one in this world is pure and perfec= t.  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 hi= m justice though in as much as he had four legs, a tail, and barked, I admi= t he was, to all outward appearances. But to those who knew him well, he wa= s a perfect gentleman (Hermione Gingold)

**Live simply **Love generously **Care deepl= y **Speak kindly.
*** Genuinely rich *** Fa= ithful talent *** Sharing success



=20
=20
On Friday, July 23, 2021, 02:07:15 PM EDT, Alvaro Aguay= o <aaguayo@opensysperu.com> wrote:


Is there any other thi= ng running with that database? If so, I would consider a locking problem. C= REATE/ALTER ROLE should never take too much time, unless there is some kind= of lock in a global catalog.

=20

 

=20

Regards,

=20

 

=20

Alvaro Aguayo

=20

Operations Manager

=20

Open = Comb Systems E.I.R.L.

=20

 

=20

From: Pepe TD Vo <pepevo@yahoo.com>
Sent: 23 July 2021 12:52
To: pgsql-admin@lists.postgresql.org
Subject: database lagging

=20

 

=20

I am doing CIS Benchmart on Postgreql 12.  After alte= r 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 n= ot, it hung there for ever.  Is there a way to fix it?

=20

 

=20

postgres=3D# create role appuser;

=20

^CCancel request sent

=20

CREATE ROLE

=20

 

=20

postgres=3D# ALTER ROLE appuser NOSUPERUSER;

=20

^CCancel request sent

=20

ALTER ROLE

=20

 

=20

 

=20

postgres=3D# ALTER ROLE appuser NOREPLICATION;=

=20

^CCancel request sent

=20

ALTER ROLE

=20

 

=20

postgres=3D# ALTER ROLE appuser NOCREATEROLE;<= /span>

=20

^CCancel request sent

=20

ALTER ROLE

=20

 

=20

postgres=3D# ALTER ROLE appuser NOHERIT;

=20

^CCancel request sent

=20

ALTER ROLE

=20

 

=20

 

=20

 

=20
------=_Part_590942_827424099.1627064821701--