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

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