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

You could do that by logging DDL as suggested, and monitoring the log.

You could also use event triggers: https://www.postgresql.org/docs/current/static/event-triggers.html

--
Scott Ribe
scott_ribe@elevated-dev.com
https://www.linkedin.com/in/scottribe/



> On Aug 28, 2018, at 2:53 AM, pavan95 <pavan.postgresdba@gmail.com> wrote:
>
> 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).