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: Mon, 27 Aug 2018 22:48:01 -0700 (MST)
Message-ID: <1535435281653-0.post@n3.nabble.com> (raw)
Hi Team,
I wanted to know if there is a way to get alerted automatically when a table
on the primary undergoes structural changes(i.e, adding/dropping some
columns ).
Due to this in Logical Replication the below error arises and replication
stops for the changed table until structure on both sides are the same.
*ERROR: logical replication target relation "public.est" is missing some
replicated columns
*
So I wanted to get notified whenever a table structure has been changed on
the Publisher Side. Is this possible?
Looking forward to hear from you!!
Regards,
Pavan
--
Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
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: <1535435281653-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