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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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





[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux