Postgres Pro
Downloads
Home   >   mailing lists

RE: pg_dump not dumping the run_as_owner setting from version 16? - Mailing list pgsql-hackers

From Philip Warner
Subject RE: pg_dump not dumping the run_as_owner setting from version 16?
Date
Msg-id 20231027070539.87C5A220F0A@thebes.rime.com.au
Whole thread Raw
In response to pg_dump not dumping the run_as_owner setting from version 16?  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: pg_dump not dumping the run_as_owner setting from version 16?
List pgsql-hackers
Tree view

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@lists.postgresql.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

 

 

pgsql-hackers by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Version 14/15 documentation Section "Alter Default Privileges"
Next
From: Étienne BERSAC
Date:
Subject: Re: RFC: Logging plan of the running query