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 Scott Ribe
Subject Re: How to get alerted automatically whenever a table structure ischanged between Publisher and Subscriber in Logical Replication?
Date
Msg-id 394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com
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>)
Responses 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 
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).

pgsql-admin by date:

Previous
From: Mariel Cherkassky
Date:
Subject: Re: Could not open file "pg_subtrans/01EB"
Next
From: wambacher@posteo.de
Date:
Subject: Re: tuple concurrently updated