On Tuesday, March 1, 2022 9:19 AM Euler Taveira <eu...@eulerto.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