RE: logical replication restrictions

On Tuesday, March 1, 2022 9:19 AM Euler Taveira <euler(at)eulerto(dot)com> wrote:
> Long time, no patch. Here it is. I will provide documentation in the next
>
> version. I would appreciate some feedback.
Hi, thank you for posting the patch !

$ git am v1-0001-Time-delayed-logical-replication-subscriber.patch

Applying: Time-delayed logical replication subscriber
error: patch failed: src/backend/catalog/system_views.sql:1261
error: src/backend/catalog/system_views.sql: patch does not apply

FYI, by one recent commit(7a85073), the HEAD redesigned pg_stat_subscription_workers.
Thus, the blow change can't be applied. Could you please rebase v1 ?

diff --git a/src/backend/catalog/system_views.sql b/src/backend/catalog/system_views.sql
index 3cb69b1f87..1cc0d86f2e 100644
--- a/src/backend/catalog/system_views.sql
+++ b/src/backend/catalog/system_views.sql
@@ -1261,7 +1261,8 @@ REVOKE ALL ON pg_replication_origin_status FROM public;
-- All columns of pg_subscription except subconninfo are publicly readable.
REVOKE ALL ON pg_subscription FROM public;
GRANT SELECT (oid, subdbid, subname, subowner, subenabled, subbinary,
- substream, subtwophasestate, subslotname, subsynccommit, subpublications)
+ substream, subtwophasestate, subslotname, subsynccommit,
+ subapplydelay, subpublications)
ON pg_subscription TO public;

CREATE VIEW pg_stat_subscription_workers AS

Best Regards,
Takamichi Osumi