public inbox for [email protected]  

help / color / mirror / Atom feed

From: Anil Sahoo <[email protected]>
To: [email protected]
Subject: Implement new options to the Subscription of pgAdmin 4
Date: Tue, 1 Aug 2023 11:55:11 +0530
Message-ID: <CAO+oWtCM1U66wgVfn=98Nd4aS0KFUAd1VCZPEs7ZoVoWBm7UEg@mail.gmail.com> (raw)

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

view thread (3+ messages)  latest in thread

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected]
  Subject: Re: Implement new options to the Subscription of pgAdmin 4
  In-Reply-To: <CAO+oWtCM1U66wgVfn=98Nd4aS0KFUAd1VCZPEs7ZoVoWBm7UEg@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox