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

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-08-28 12:11:52
Message-ID: 394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

You could do that by logging DDL as suggested, and monitoring the log.

You could also use event triggers: https://www.postgresql.org/docs/current/static/event-triggers.html

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
https://www.linkedin.com/in/scottribe/

> On Aug 28, 2018, at 2:53 AM, pavan95 <pavan(dot)postgresdba(at)gmail(dot)com> wrote:
>
> So looking for a any table structure modifications(mainly alter DDL) if
> changed in a publisher I need to receive an alert(through any custom script
> or via a mail).

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message wambacher 2018-08-28 13:04:14 Re: tuple concurrently updated
Previous Message Mariel Cherkassky 2018-08-28 11:33:08 Re: Could not open file "pg_subtrans/01EB"