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

From: Evan Bauer <evanbauer(at)mac(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 16:43:41
Message-ID: 369474F6-47EE-414E-9B9F-A0CB6811B09C@mac.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Pavan,

One more thought: Using a log aggregation and analysis tool like ELK would provide a simple way to alert and trigger on DDL actions captured in the log record — as well as give you a solid monitoring solution for Odoop — a Java web app that gives u=you almost no production monitoring out of the box.

Cheers,

- Evan

Evan Bauer
eb(at)evanbauer(dot)com
+1 646 641 2973
Skype: evanbauer

> On Sep 5, 2018, at 07:14, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:
>
> I just wanted to confirm if there is any other way to achieve this. It's not
> like I don't like that answer.
>
> Anyways, thanks for answering.
>
> Regards,
> Pavan
>
>
>
> --
> Sent from: http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html
>

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Stephen Frost 2018-09-05 17:48:32 Re: User to get locked after three wrong login attempts.
Previous 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?