From: | Anil Sahoo <anil(dot)sahoo(at)enterprisedb(dot)com> |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | Implement new options to the Subscription of pgAdmin 4 |
Date: | 2023-08-01 06:25:11 |
Message-ID: | CAO+oWtCM1U66wgVfn=98Nd4aS0KFUAd1VCZPEs7ZoVoWBm7UEg@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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
--
*Anil Sahoo*
Software Engineer
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/>
Attachment | Content-Type | Size |
---|---|---|
Subscription_PGv15.png | image/png | 187.4 KB |
Subscription_PGv16.png | image/png | 161.4 KB |
Subscription_PGv14.png | image/png | 198.0 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | dependabot[bot] | 2023-08-01 07:05:07 | [pgadmin-org/pgadmin4] 4920d2: JS dependency: Bump html-react-parser from 1.4.14 ... |
Previous Message | Khushboo Vashi | 2023-08-01 04:41:05 | Re: EDB installer still includes 7.4 and is broken |