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