Postgres Pro
Downloads
Home   >   mailing lists

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

From Adrien NAYRAT
Subject Re: How to get alerted automatically whenever a table structure ischanged between Publisher and Subscriber in Logical Replication?
Date
Msg-id 6801b80f-c3a0-a252-d110-38496b12f060@anayrat.info
Whole thread Raw
In response to Re: How to get alerted automatically whenever a table structure ischanged between Publisher and Subscriber in Logical Replication?  (pavan95 <pavan.postgresdba@gmail.com>)
List pgsql-admin
Tree view 
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

pgsql-admin by date:

Previous
From: pavan95
Date:
Subject: Re: How to get alerted automatically whenever a table structure ischanged between Publisher and Subscriber in Logical Replication?
Next
From: wambacher@posteo.de
Date:
Subject: tuple concurrently updated