pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Stephen Frost <sfrost@snowman.net>
To: Scott Ribe <scott_ribe@elevated-dev.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
Date: Wed, 9 Dec 2020 15:26:14 -0500
Message-ID: <20201209202614.GG16415@tamriel.snowman.net> (raw)
In-Reply-To: <6EA7B05C-A186-4288-9381-35E4219D39D7@elevated-dev.com>
References: <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>
	<B292176F-B507-498F-975B-3548D73A8352@elevated-dev.com>
	<20201209192406.GD16415@tamriel.snowman.net>
	<F2A313AD-7C0F-43E8-9D60-6A6515409E3D@elevated-dev.com>
	<20201209195954.GF16415@tamriel.snowman.net>
	<6EA7B05C-A186-4288-9381-35E4219D39D7@elevated-dev.com>

Greetings,

* Scott Ribe (scott_ribe@elevated-dev.com) wrote:
> > On Dec 9, 2020, at 12:59 PM, Stephen Frost <sfrost@snowman.net> wrote:
> > 
> > Well, pg_dump here doesn't emit any GRANT commands for that table when
> > run and the table has those privileges, so something doesn't add up.
> > 
> > Are you sure you're looking at the right database?  Do you see GRANT or
> > REVOKE commands for that table when you run pg_dump by hand..?
> 
> I'm pretty sure Tom Lane got it, because I see all sorts of privs in the pg_default_acl table that shouldn't be there, whereas privs on the table are normal.

Well, we're all just shooting in the dark here since you didn't really
provide enough specifics to actually be able to determine what's going
on.

Privileges in pg_default_acl aren't going to cause pg_dump to issue
GRANT commands, which is what was in the initial problem description.

Thanks,

Stephen

Attachments:

  signature.asc (application/pgp-signature, 818B) download

view thread (25+ messages)  latest in thread

Message-ID: <20201209202614.GG16415@tamriel.snowman.net>
Permalink:  ../20201209202614.GG16415@tamriel.snowman.net/
Also on:    postgresql.org/message-id/20201209202614.GG16415@tamriel.snowman.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: sfrost@snowman.net, scott_ribe@elevated-dev.com, tgl@sss.pgh.pa.us, pgsql-admin@lists.postgresql.org
  Subject: Re: 12 to 13 migration, the privs error with pg_pltemplate
  In-Reply-To: <20201209202614.GG16415@tamriel.snowman.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox