Implement new options to the Subscription of pgAdmin 4

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

--

<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/>

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

Responses

Browse pgadmin-hackers by date

  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