public inbox for [email protected]help / color / mirror / Atom feed
Implement new options to the Subscription of pgAdmin 4 3+ messages / 2 participants [nested] [flat]
* Implement new options to the Subscription of pgAdmin 4 @ 2023-08-01 06:25 Anil Sahoo <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Anil Sahoo @ 2023-08-01 06:25 UTC (permalink / raw) To: pgadmin-hackers 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 -- <http://www.enterprisedb.com; *Anil Sahoo* Software Engineer www.enterprisedb.com Power to Postgres <https://www.linkedin.com/company/edbpostgres; <https://twitter.com/edbpostgres?lang=en; <https://www.facebook.com/EDBpostgres; <https://www.instagram.com/EDBpostgres/; Attachments: [image/png] Subscription_PGv15.png (187.4K, 3-Subscription_PGv15.png) download | view image [image/png] Subscription_PGv16.png (161.4K, 4-Subscription_PGv16.png) download | view image [image/png] Subscription_PGv14.png (198.0K, 5-Subscription_PGv14.png) download | view image ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Implement new options to the Subscription of pgAdmin 4 @ 2023-08-02 06:51 Akshay Joshi <[email protected]> parent: Anil Sahoo <[email protected]> 0 siblings, 1 reply; 3+ messages in thread From: Akshay Joshi @ 2023-08-02 06:51 UTC (permalink / raw) To: Anil Sahoo <[email protected]>; +Cc: pgadmin-hackers 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 <[email protected]> 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 > > -- > > <http://www.enterprisedb.com; > > *Anil Sahoo* > > Software Engineer > > www.enterprisedb.com > > Power to Postgres > > <https://www.linkedin.com/company/edbpostgres; > <https://twitter.com/edbpostgres?lang=en; > <https://www.facebook.com/EDBpostgres; > <https://www.instagram.com/EDBpostgres/; > ^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Implement new options to the Subscription of pgAdmin 4 @ 2023-08-02 06:53 Anil Sahoo <[email protected]> parent: Akshay Joshi <[email protected]> 0 siblings, 0 replies; 3+ messages in thread From: Anil Sahoo @ 2023-08-02 06:53 UTC (permalink / raw) To: Akshay Joshi <[email protected]>; +Cc: pgadmin-hackers Hi Akshay, I will be adding a help message to each control, So it will take the whole row and will be easier to understand the control as well. <http://www.enterprisedb.com; *Anil Sahoo* Software Engineer www.enterprisedb.com Power to Postgres <https://www.linkedin.com/company/edbpostgres; <https://twitter.com/edbpostgres?lang=en; <https://www.facebook.com/EDBpostgres; <https://www.instagram.com/EDBpostgres/; On Wed, Aug 2, 2023 at 12:21 PM Akshay Joshi <[email protected]> wrote: > 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 <[email protected]> > 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 >> >> -- >> >> <http://www.enterprisedb.com; >> >> *Anil Sahoo* >> >> Software Engineer >> >> www.enterprisedb.com >> >> Power to Postgres >> >> <https://www.linkedin.com/company/edbpostgres; >> <https://twitter.com/edbpostgres?lang=en; >> <https://www.facebook.com/EDBpostgres; >> <https://www.instagram.com/EDBpostgres/; >> > ^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2023-08-02 06:53 UTC | newest] Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2023-08-01 06:25 Implement new options to the Subscription of pgAdmin 4 Anil Sahoo <[email protected]> 2023-08-02 06:51 ` Akshay Joshi <[email protected]> 2023-08-02 06:53 ` Anil Sahoo <[email protected]>
This inbox is served by agora; see mirroring instructions for how to clone and mirror all data and code used for this inbox