Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
Date: 2018-08-28 05:48:01
Message-ID: 1535435281653-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Adrien NAYRAT 2018-08-28 07:39:31 Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
Previous Message Scott Ribe 2018-08-28 03:31:39 Re: Database Connectivity Issue with DB Lookup