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

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: "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:05:30
Message-ID: 20231027070539.87C5A220F0A@thebes.rime.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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

Sent from Mail for Windows

From: Philip Warner
Sent: Friday, 27 October 2023 3:26 PM
To: pgsql-hackers(at)lists(dot)postgresql(dot)org
Subject: pg_dump not dumping the run_as_owner setting from version 16?

Hi,

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.

Sent from Mail for Windows

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Étienne BERSAC 2023-10-27 07:06:31 Re: RFC: Logging plan of the running query
Previous Message Laurenz Albe 2023-10-27 07:03:04 Re: Version 14/15 documentation Section "Alter Default Privileges"