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 1m6zLd-0005Gx-3I for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 17:52: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 1m6zLb-0004zx-HM for pgsql-admin@arkaria.postgresql.org; Fri, 23 Jul 2021 17:52: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 1m6zLb-0004zf-63 for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 17:52:31 +0000 Received: from sonic311-24.consmr.mail.ne1.yahoo.com ([66.163.188.205]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1m6zLY-0004jX-Jl for pgsql-admin@lists.postgresql.org; Fri, 23 Jul 2021 17:52:30 +0000 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627062745; bh=kChksy4rpHMoUIjq82Xod3sXlx0X8FJSBdZ+l8VA/sA=; h=Date:From:Reply-To:To:Subject:References:From:Subject:Reply-To; b=SgAZEYq7hZ+EGjiniIgv1oW4+cpGnSE81OVK+EP/AJOgaBNxoyL9KDlllKB4N7aqEzFyBJqbtjgespv8vu0yminHrXs24iO7KMSqnNIwSyhTjNRxE7iF1Py0o5tsSYcZTTZNXr+91fMJ4cnUhcgJAFUSEglgbvKRNb0HKlnlemaW5TrjCAOKBSqmTIzDb4UT1k9y8gzDTswOzYuUaE9GgcOxpDfhDtwA03g6jOGD3fw3M80dyKQYY4GOTr23zouEit0QyLyVyp60zXIoUg+KEzojY3Bj+Oz1CqAiBOHSCdkZEUywgY8UuaXgpehpRFb83hPGX/bxjHSSVU1A1FWIZg== X-SONIC-DKIM-SIGN: v=1; a=rsa-sha256; c=relaxed/relaxed; d=yahoo.com; s=s2048; t=1627062745; bh=r2Nmh9G8K2kCi6MwnQ94m4yTHr1M3tt0bgfLpGms+h0=; h=X-Sonic-MF:Date:From:To:Subject:From:Subject; b=myGEK0P5nbqUNPJyX5T0gmY7THbcsMMR0Rhm48KzfWMsWRfPuBVSwRRC3iXH9H43/s57sXLGM6Nt33mom5GCOdAorT/WUWmyxyRFnP3Yez35oMXsKP0DViv0zZHWnGJVQ5ahjuUzaJ1tPh7R7u0t2Z+k4xLt1TFxFtmAEV99wOAS5eU2t22X127EJuX8SMgienX97W2/093JyNPl4oE6YO8/d+58jlx1Jxd1y9bV2yGA+0uPT/1CczOUmqdEAMiScSEenKq3N3x+Igmz8ou/a7QGJKkw8IOjWT8Q+EYoIjYPBOZAuQIwIyqywmOjcnKLyhAnYAurZdym9L+rXqsREA== X-YMail-OSG: 3yTC9FMVM1lIYUqBuITQq_QlD08feU7fhk722V6OEk3AsXDQEkAHsDXuPtslHuw li74nS2dIMXajbvc.VI0GoKp95iLRKiUm.nzEuyFpb.PADd0GqxuoQ5XUJP6OAbf5Hejdq2eJ3kd Hb_vg_3mLk92Q6eIGKzeWlB2JlDBGAiNk3piT4a2_.8Yk0NLdtsnYpxrikJ4PLtHA88PuAssY_S0 aPRbVEsqb71FRn.GTTxJ_QDeDNzrz2tm_i1RePqChve8vEC3aG49.yFwziN9aMctChAY9Vh7Pi4b HZsDxyKmXvPM9t1oFOhxp0ndwpEJ1IR0tcIauD1tadF.m.9FpRXLCq4dG6ZmEO0oBPcvMihsUcar 47nXpMlZuFNff890yvi.RyoRw3H7sRGFcQlq.iqDRdKAlUb6Y73kW26.ws3gYUV3_7oR3xjqG9UB 7ZInkIPQTnGBiDhPUDZm0tZFoX8QZ.u4mIVMLDVF9hOn2Gt.z8lucfevHDYV7jw2abjRJL520x6i gViomJpTq0Ff.WGJ9huGkH95C5n8otfulYCRYfG087z3knq6ELMt0havEE7CUtj7VOH3vwlDchDu d7petQ9zCi3ugXZM0uEts99OYXLYkXXWP0oqfro5KV3_czEYnguwQU6LEBdrc4wLEUb.7BvshuGo XZcJM2YqZeO1fX81QZZZpWOWP9gutwqZG185FuDE7KA3np0LabTOs.w15wGM3Mp.EK7gV_T4TTb0 8kNmG6ADXbL0WvNksEFt_ElFDhAKN5DSmBDhpe73NDZDS8Arn6oPTyk_EpOw4T6VUO8j_XV9ACff oTzE9b426QIYvFkqVKBCtT7616iM_zKxi8o7rYwN6O1NvuWOcNrG9ktpEoZePaJUqFmhm3Gk9J9D NWz5gK.ilMY.OrLDBAmibhp1lEtYfr25wZwtsxiJHMFnN9s_Mh395nUGDZyxZeUKn0y6nVz7p3.R vhgxwQVHyMBx2FLBLb6k9SIjhuwOF_1ivrnnLstourdYtrtB4k1QRPdzm5R6fQQiRsDntOYrUR81 g_HI9qFHAsZSX_nlTXA71gQO_289VBmaJ1FIJMEWSIYR.PkhOoNIKsxB4CJ1ghJhyEfsqLPhgW5o 8zp9BZH9PKMWT22ERjDyXW36_s3retcT7omGLWC77JV_0vj9kX.kTjb11Kuvlszjr2EG_S2t3gYS oRoDwwCbSzrqinIKr1alQXTk9aDezXOTzX3KouQKG1nkGmF_XFUCrLaJxcciQ8HApt36iP1xFa3w FNR2z6B7kiYQBGAqzxPCUhKFmuxnDRu6KWzNr8TO9AKAiX6ma760SvkQ0NKK3vAtzOxdIq2vF6Hx t7i0Lz51EF6hMODCVel3sai0k_B.6OONe9smizbOKN0TlpIxeBSjiFRdnlAevrFjyMKv9W51c61y aH0ceQ9jySrke_vX1oR8QwWicIdFnkKHVZgiJTjvmyoCgt07TgNWG1wY9zSZl9e_JuHKCd6JUQ9r 0rDI4Cx004CWWgJwfwHlFLMtX5HfBDS5AhFRNy14CXQI1oYvfB8pUELfWXFilPgc43MmiAVkEg.r uZ5E_Rwk6l.uz6HXm1WPM4O2MIZ3iIZB6LPDaKir4X6XfuYtnEOd.hReLxG68r7Qyn03rogH1Wc7 dSAtx9hf7n.JjIdw3WrSsCnT41Z3zIIytyfxRhGKDoJjHSK_bvCnUpo30kzoV1PFyTm5l7pjfRKk u7zjqWLLJsS7uO8TGbjqZ0npN3vl3cpEA9_GCcohXu1hChJYfCFrUnTZEYqgO_llghskJFd7Ps9T cLYFYJaQGS8Ct8V.BAyH6lttHcVZbYgwYAtrWuQFTXSoEixpgt8EHxZH04dC8G.IkOfcBavp1X8f syh7w9InY8Kxn52Ny6GjGE.FwNyKyroN2xz1CMtqvml3AszrAkV6vLk59Z9.z1X.V.S1upvMjSBK XFAO65QPu_gx8hEr5tIkWrVzqoOThV697CU9sQXwUuBUPbQNgd_nn8o7WeGbI_fVZrl4d5C.VCRv 1uOl6uUf7RCrxHbkHLIf.8DBkg5iCVdeT7rgYsxTuWaIZQbwInH5doe76.wR35YZKKYvAHjgvWVx z9UR0BYFGozNxDF.1v3F8e0YLbEs3Gkl5dRFTHEUGuAMD8MxNBBB73w2kwhsu2fteUeo4QXovYMQ CkrQOMP8BF.Smx.JB0ozeaOcHdhS3qk4BXEazj_LPkP6mruSV7_nD5tYEAqlnTBLBWS4cOR7Xrab DIkXpRqK6vaxdDO1p9iQBKLfRb.Cg.HEQ9IVlMqZLbklSltCrt3F6BeLCAZQu_Dk_w_6bpoHFSxG NdCMu.LJIdhnXiMKgto6U2OnAIp9GpJFrP.53hmeGPwgvM0SvAOVXRiNjiyp_8JgDh_oFqqz6m4w dsSC8NZPOlLfD1ad5kCVRI0Q72Zea9YmjK9W1nvu9lwo7hQHItURALdEaeM6yYAcvlrosJ8KamL. EAtddKIpa5MGVUx3EwXGBSwXJKWm8pg-- X-Sonic-MF: Received: from sonic.gate.mail.ne1.yahoo.com by sonic311.consmr.mail.ne1.yahoo.com with HTTP; Fri, 23 Jul 2021 17:52:25 +0000 Date: Fri, 23 Jul 2021 17:52:21 +0000 (UTC) From: Pepe TD Vo Reply-To: Pepe TD Vo To: "pgsql-admin@lists.postgresql.org" Message-ID: <1396983439.574027.1627062741652@mail.yahoo.com> Subject: database lagging MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_574026_1247424760.1627062741651" References: <1396983439.574027.1627062741652.ref@mail.yahoo.com> X-Mailer: WebService/1.1.18736 YMailNorrin Content-Length: 5300 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk ------=_Part_574026_1247424760.1627062741651 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable 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 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 ------=_Part_574026_1247424760.1627062741651 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
I am doing CIS Benchmart on Postgreql 12.  Aft= er alter parameters and when I tried to create a new role.  It's laggi= ng 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 e= ver.  Is there a way to fix it?

postgres=3D# create = role appuser;
^CCancel request = sent
CREATE ROLE

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

 
postgres=3D# ALTER ROLE appuser NOREPLICATION;
^CCa= ncel request sent
ALTER ROLE
=
postgres=3D# ALTER ROLE appus= er NOCREATEROLE;
^CCancel request sent
ALTER ROLE

post= gres=3D# ALTER ROLE appuser NOHERIT;
^CCancel request s= ent
ALTER ROLE


=

------=_Part_574026_1247424760.1627062741651--