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

From: pavan95 <pavan(dot)postgresdba(at)gmail(dot)com>
To: pgsql-admin(at)postgresql(dot)org
Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication?
Date: 2018-09-05 09:42:11
Message-ID: 1536140531829-0.post@n3.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Dave Cramer 2018-09-05 10:50:42 Re: postgresql Logical Replication Stream fails with “Database connection failed when reading from copy”
Previous Message pavan95 2018-09-05 09:30:48 Re: Heavy Logging in Subscriber side when configured Logical Replication in 10.4