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 09:11:26
Message-ID: 6801b80f-c3a0-a252-d110-38496b12f060@anayrat.info
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On 8/28/18 10:53 AM, pavan95 wrote:
> Hi Adrien,
>
> Thanks for your prompt response.
>
> In my case I'm not interested in capturing DDL's instead I'm interested in
> capturing the altered tables, I mean to say if any column was added/removed
> from the table, it causes replication to stop and trigger continuous errors
> in the log file as said before.
>
> So looking for a any table structure modifications(mainly alter DDL) if
> changed in a publisher I need to receive an alert(through any custom script
> or via a mail).
>

I do not test, may check_postgres do the job:
https://bucardo.org/check_postgres/check_postgres.pl.html#same_schema

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message wambacher 2018-08-28 10:36:03 tuple concurrently updated
Previous 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?