From: Scott Ribe <scott_ribe@elevated-dev.com>
To: pavan95 <pavan.postgresdba@gmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
Date: Tue, 28 Aug 2018 06:11:52 -0600
Message-ID: <394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com> (raw)
In-Reply-To: <1535446386936-0.post@n3.nabble.com>
References: <1535435281653-0.post@n3.nabble.com>
<7f636d45-36db-d87b-171a-519e21690574@anayrat.info>
<1535446386936-0.post@n3.nabble.com>
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).
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott_ribe@elevated-dev.com, pavan.postgresdba@gmail.com
Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
In-Reply-To: <394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox