Implement new options to the Subscription of pgAdmin 4 - Mailing list 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:
- binary(boolean): Specifies whether the subscription will request the publisher to send the data in binary format.
- streaming(boolean): Specifies whether streaming of in-progress transactions should be enabled for this subscription.
For PostgreSQL 15 and above:
- two_phase(boolean): Specifies whether two-phase commit is enabled for this subscription.
- 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:
- password_required(boolean): Specifies whether connections to the publisher made as a result of this subscription must use password authentication.
- 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.
- 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
--
Attachment
pgadmin-hackers by date: