On 8/28/18 7:48 AM, pavan95 wrote:
Hi Team, I wanted to know if there is a way to get alerted automatically when a table on the primary undergoes structural changes(i.e, adding/dropping some columns ). Due to this in Logical Replication the below error arises and replication stops for the changed table until structure on both sides are the same. *ERROR: logical replication target relation "public.est" is missing some replicated columns * So I wanted to get notified whenever a table structure has been changed on the Publisher Side. Is this possible? Looking forward to hear from you!! Regards, Pavan
Hi, Maybe log_statement = ddl ? You will have informations in logs. Regards,
