Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYcH9-0002Q7-Bz for pgsql-admin@arkaria.postgresql.org; Tue, 31 Jan 2017 17:31:27 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cYcH8-0001Ek-Oh for pgsql-admin@arkaria.postgresql.org; Tue, 31 Jan 2017 17:31:26 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cYcFR-0007f9-7f for pgsql-admin@postgresql.org; Tue, 31 Jan 2017 17:29:41 +0000 Received: from tamriel.snowman.net ([72.66.115.51]) by makus.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cYcFO-0006Jf-Ki for pgsql-admin@postgresql.org; Tue, 31 Jan 2017 17:29:39 +0000 Received: by tamriel.snowman.net (Postfix, from userid 1000) id 1F07A5F794; Tue, 31 Jan 2017 12:28:38 -0500 (EST) Date: Tue, 31 Jan 2017 12:28:38 -0500 From: Stephen Frost To: Jorge Torralba Cc: "pgsql-admin@postgresql.org" Subject: Re: New message pg_dumpall role skiped ??? Message-ID: <20170131172837.GO9812@tamriel.snowman.net> References: MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha512; protocol="application/pgp-signature"; boundary="skXTemeSi08hLmdc" Content-Disposition: inline In-Reply-To: X-Editor: Vim http://www.vim.org/ X-Info: http://www.snowman.net X-Operating-System: Linux/3.13.0-91-generic (x86_64) X-Uptime: 12:25:46 up 206 days, 18:50, 7 users, load average: 0.05, 0.12, 0.15 User-Agent: Mutt/1.5.21 (2010-09-15) X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org --skXTemeSi08hLmdc Content-Type: text/plain; charset=us-ascii Content-Disposition: inline Content-Transfer-Encoding: quoted-printable Greetings Jorge, * Jorge Torralba (jorge.torralba@gmail.com) wrote: > pg_dumpall: role name starting with "pg_" skipped That message should also tell you what the role name was which was skipped by pg_dumpall. > Looking at the source looks like it was committed back in April. >=20 > What was the reason for this and can the messages be suppressed? This was added because it means that a role which exists in your pre-9.6 version of PG begins with "pg_" and is not included in the pg_dumpall output. The best way to address this is to rename your role to not include the "pg_" prefix as that prefix is now reserved for system-defined roles (just like schemas). Thanks! Stephen --skXTemeSi08hLmdc Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1 iQIcBAEBCgAGBQJYkMlFAAoJEO1sijiDR2RV8zoP/0PLK+s/fd/3ATZyZsEDy87x ipoWB1+vPFbeX3ueR+NOXxjQaXS8+m+RVAO52VcMkiwoOtwqXAfOJuHBAfnov4Pd 3gFDoZyYkx20JkgY0bz3un/+q7x+9xayRXh9fqT4qXmcluadCugy2TKqFrLnTf0m IqoUEwEEUmn9Zjg+uTpBLMRU7r97KsrGsVRzB5/yAkRiQx3EoA5iU942w2cadMjs I2WkNLCO4UppBcgHboM2Hcthcvp4hiUdbYRsGYkfJ42rHs3iL1IXYtTbzAgRF9Ul bL89bN3kX2sxvEAcxMgo87Vr8t2TCsvUdUqfQLxpqaBoAlFjgSBeQHHy2P6XiZMu Ya6O6imNvZVze5NUf1SyXVasCITELK1H0VaHbOlPePCleOHg07v6Xnrmz8h2fG/p zoUjjVQ0Jgal2nTwH8n1096I1xGK9Udn1apUEYYhUaoLipiDFsOLPxF3VmWuIuLC zK55osZmji+cx8p1LuYaCHrrb1FqGpWA9d48a+iV9wPC48za2FjaaDgvdXYiigWO IGFf78r9CCEhBLQKEjK+ok5JDrwL2s5xmk7lUQdJMMgWPCH5ck3Tc4AyEuLxa5k3 NKE5MMeS/E2IBguLgnvBhfcRIcemVvyzZsUaDVq0hrBYW2kcBl4nkVNCTpnCk1wY my0RNLS+wi09Ilm5QUFZ =a9nT -----END PGP SIGNATURE----- --skXTemeSi08hLmdc--