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 1kn54N-0003j5-U3 for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 19:24:11 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn54M-0003RQ-NQ for pgsql-admin@arkaria.postgresql.org; Wed, 09 Dec 2020 19:24:10 +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 1kn54M-0003RJ-Fx for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 19:24:10 +0000 Received: from tamriel.snowman.net ([2001:470:e38f::11]) by makus.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1kn54J-0004zl-GL for pgsql-admin@lists.postgresql.org; Wed, 09 Dec 2020 19:24:09 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 05E1C5F799; Wed, 9 Dec 2020 14:24:06 -0500 (EST) Date: Wed, 9 Dec 2020 14:24:06 -0500 From: Stephen Frost To: Scott Ribe Cc: Tom Lane , Pgsql-admin Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate Message-ID: <20201209192406.GD16415@tamriel.snowman.net> References: <074FE83A-E924-4787-9E68-27EB9CE142B3@elevated-dev.com> <3264512.1607456932@sss.pgh.pa.us> <154608A6-0F38-4BE8-B3F4-3E3308691F91@elevated-dev.com> <2BD26D52-19B8-42CD-860D-B9AE21AF5C61@elevated-dev.com> <3632844.1607534358@sss.pgh.pa.us> <68634B7E-3AD0-42A3-9A2D-EC3988E755E4@elevated-dev.com> <20201209184925.GA16415@tamriel.snowman.net> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="f2hFKuRvZleL7Mo6" Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --f2hFKuRvZleL7Mo6 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings, * Scott Ribe (scott_ribe@elevated-dev.com) wrote: > > On Dec 9, 2020, at 11:49 AM, Stephen Frost wrote: > > REVOKE'ing the privileges on the > > catalog tables/columns that are causing an issue should resolve it > > though. >=20 > I tried REVOKE ALL, no joy. Given where Tom pointed me, perhaps I need to= give ALTER DEFAULT PRIVILEGES a try. Are you sure you have privileges to perform the REVOKE and that it actually did something..? Check the results in psql using: =3D> \dp pg_catalog.pg_pltemplate=20 (or whatever catalog table it is the GRANT's are being created for in the pg_dump) What you'd want is something like: Access privileges Schema | Name | Type | Access privileges | Column pr= ivileges | Policies=20 ------------+---------------+-------+---------------------------+----------= ---------+---------- pg_catalog | pg_pltemplate | table | postgres=3DarwdDxt/postgres+| = |=20 | | | =3Dr/postgres | = |=20 (1 row) Thanks, Stephen --f2hFKuRvZleL7Mo6 Content-Type: application/pgp-signature; name="signature.asc" -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJf0SRWAAoJEO1sijiDR2RVr60QALe74rMSuHkmg+6ZTlZgzN/f ngjjw7xFVe6xSr9usp+S/NyWOw7tsBP0VhAhzERaTd7WiRx6pI3S8lKXmf/uOFpi QhKdiqNoDF2BUoCqoZc6pAGPh18/+cKyZuPbY/6pZB/0S8zYWYhA3OlBADB2N/6J VvQIAk9Iaei5MplVUnIUfVd8ORObutDjQNGfINIM13KrAh/pvT4wSF/rHoVn6/nr lDgMS3i9ax/+TwzVk55DjzAT1jBdXCqQaB+y10WDksoYTW6uC2+dgRuM67ga1FEv Wz+FE7ye5FAokdqNp1X7mHo8WRLuQEaJ8H2D6OAqsy+Mf/f8bBWl+5LdD5kX1gSQ CTorwlUG1cx1sXCkfU1jdIJibbLCHrtNDOc0Jx8vBJV/qFw3TwAyUvch9W1+bb/Z eCSM01Hkl97oC6RcjktYtTDxTiDCsewtGl91Z+wkChDXuzO0O+VWUu0ptw3V8cmE 4pDItjKGRqSvjSc6lS7m86d++AfPwBucQ91qg3uUxT5h88Rlp3Z+OM1ihbsRRenu 1uAF9xZKRAt9XbPkkj2fuHzGoaS5yoMIkgL65PeipMiex/mIzxDInPt891O1cxlR 9M8RlhaMRP2M9GivrxEg2bloFCoyeW7Elh5+8RARC/dzOhHxRWcCOKXcr7dZUBNg GWPtJBo5tWXejet8GkN2 =Jnut -----END PGP SIGNATURE----- --f2hFKuRvZleL7Mo6--