RE: Selectively invalidate caches in pgoutput module - Mailing list pgsql-hackers

From Hayato Kuroda (Fujitsu)
Subject RE: Selectively invalidate caches in pgoutput module
Date
Msg-id OSCPR01MB149661933DF061B6A9C2E0804F5A02@OSCPR01MB14966.jpnprd01.prod.outlook.com
Whole thread Raw
In response to Re: Selectively invalidate caches in pgoutput module  (Amit Kapila <amit.kapila16@gmail.com>)
Responses Re: Selectively invalidate caches in pgoutput module
List pgsql-hackers
Dear Amit,

> The problem here is that after ALTER SUBSCRIPTION tap_sub SET
> PUBLICATION ..., we didn't wait for the new walsender on publisher to
> start. We must use wait_for_subscription_sync both after the "CREATE
> SUBSCRIPTION ..." and the "ALTER SUBSCRIPTION ..." commands and keep
> copy_data=true to ensure the initial replication is setup between
> publisher and subscriber. This is how we use these commands at other
> places.

Agreed. PSA the patch to fix the issue.

Best regards,
Hayato Kuroda
FUJITSU LIMITED


Attachment

pgsql-hackers by date:

Previous
From: Jeff Davis
Date:
Subject: Re: Statistics import and export: difference in statistics of materialized view dumped
Next
From: Masahiko Sawada
Date:
Subject: Re: UUID v7