Re: pg_dump not dumping the run_as_owner setting from version 16?

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>, "pgsql-hackers(at)lists(dot)postgresql(dot)org" <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump not dumping the run_as_owner setting from version 16?
Date: 2023-10-27 07:52:31
Message-ID: 051e7f1442f289cf3cd16e5681072b340007ec0f.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Fri, 2023-10-27 at 18:05 +1100, Philip Warner wrote:
> I as far as I can tell, pg_dump does not dup the ‘run_as_owner` setting for a subscription.
>
> Should it? Should I submit a patch? It seems pretty trivial to fix if anyone else is working on it.

Yes, it certainly should. That is an omission in 482675987b.
Go ahead and write a fix!

> Further to this: it seems that `Alter Subscription X Set(Run_As_Owner=True);`
> has no influence on the `subrunasowner` column of pg_subscriptions.

This seems to have been fixed in f062cddafe.

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Alvaro Herrera 2023-10-27 08:31:54 Re: A recent message added to pg_upgade
Previous Message Michael Paquier 2023-10-27 07:50:45 Re: Reconcile stats in find_tabstat_entry() and get rid of PgStat_BackendFunctionEntry