From: | Scott Ribe <scott_ribe(at)elevated-dev(dot)com> |
---|---|
To: | pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> |
Cc: | 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 13:32:04 |
Message-ID: | 03A7216C-C55D-45A2-8EEB-00E4229577E5@elevated-dev.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
You've gotten the answer, multiple times. Just because you don't like, doesn't mean that asking the question over and over will change the answer.
You'll have to get the DDL from the logs.
--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/
> On Sep 5, 2018, at 3:42 AM, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:
>
> 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
>
From | Date | Subject | |
---|---|---|---|
Next Message | pavan95 | 2018-09-05 14:14:32 | Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication? |
Previous Message | Jammie | 2018-09-05 11:35:36 | Re: postgresql Logical Replication Stream fails with “Database connection failed when reading from copy” |