Re: Implement new options to the Subscription of pgAdmin 4

Hi Anil

I would suggest getting the 'Origin' field after streaming and making two switch controls in one row as we did in the Backup dialog. If you are adding a help message to the switch controls then leave it as it is.

Apart from that it looks good to me.

On Tue, Aug 1, 2023 at 11:56 AM Anil Sahoo <anil.sahoo@enterprisedb.com> wrote:

Hi Hackers,

I am currently working on the features #4805 and #6454. There are some new options being added to the WITH clause of subscription that are listed below.

For PostgreSQL 14 and above:

1. binary(boolean): Specifies whether the subscription will request the publisher to send the data in binary format.
   
2. streaming(boolean): Specifies whether streaming of in-progress transactions should be enabled for this subscription.

For PostgreSQL 15 and above:

1. two_phase(boolean): Specifies whether two-phase commit is enabled for this subscription.
   
2. disable_on_error(boolean): Specifies whether the subscription should be automatically disabled if any errors are detected by subscription workers during data replication from the publisher.

For PostgreSQL 16 and above:

1. password_required(boolean): Specifies whether connections to the publisher made as a result of this subscription must use password authentication.
   
2. run_as_owner(boolean): If true, all replication actions are performed as the subscription owner. If false, replication workers will perform actions on each table as the owner of that table.
   
3. origin(string): Specifies whether the subscription will request the publisher to only send changes that don't have an origin or send changes regardless of origin.

Attaching the respective screenshots of the updated UI for reference. Please review it.

Thanks

Anil Sahoo

--

	Anil Sahoo Software Engineer www.enterprisedb.com Power to Postgres