pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: pavan95 <pavan.postgresdba@gmail.com>
To: 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: Wed, 5 Sep 2018 02:42:11 -0700 (MST)
Message-ID: <1536140531829-0.post@n3.nabble.com> (raw)
In-Reply-To: <1535462695414-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>
	<394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com>
	<1535462695414-0.post@n3.nabble.com>

Team, 

Any advices on this??  Looking for alerting mechanism and in the case of
event triggers can I capture the exact statement text so that it can be
executed on the subscriber.

*Note*: The DDL commands are not executed by the any one by connecting to
the database. They are executed by the Application Odoo in the front end. So
in this scenario how will I get benefitted to capture the same.

Looking forward to hear from you.

Regards,
Pavan




--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html




view thread (10+ messages)  latest in thread

Message-ID: <1536140531829-0.post@n3.nabble.com>
Permalink:  ../1536140531829-0.post@n3.nabble.com/
Also on:    postgresql.org/message-id/1536140531829-0.post@n3.nabble.com

 · 

reply
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: 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: <1536140531829-0.post@n3.nabble.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