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

From: Adrien NAYRAT <adrien(dot)nayrat(at)anayrat(dot)info>
To: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>, <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 07:39:31
Message-ID: 7f636d45-36db-d87b-171a-519e21690574@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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,

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message pavan95 2018-08-28 08:53:06 Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
Previous Message pavan95 2018-08-28 05:48:01 Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?