Received: from malur.postgresql.org ([2a02:16a8:dc51::56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxauK-0002lD-3G for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 16:43:56 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxauI-00028R-8P for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 16:43:54 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxauH-00028K-Nj for pgsql-admin@lists.postgresql.org; Wed, 05 Sep 2018 16:43:54 +0000 Received: from st14p37im-asmtp001.me.com ([17.41.209.30]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1fxauE-0007Xp-UR for pgsql-admin@postgresql.org; Wed, 05 Sep 2018 16:43:52 +0000 Received: from process-dkim-sign-daemon.st14p37im-asmtp001.me.com by st14p37im-asmtp001.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) id <0PEL00200CYZXF00@st14p37im-asmtp001.me.com> for pgsql-admin@postgresql.org; Wed, 05 Sep 2018 16:43:47 +0000 (GMT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=mac.com; s=04042017; t=1536165827; bh=29oVqgjLVrJWNEJ6rW8VevOH/5e3X3E8+8eAMPbotwI=; h=Content-type:MIME-version:Subject:From:Date:Message-id:To; b=omGrgP6+vQ56JN4jr1V53eSPc8EqYeUYfetA00EEm1Ydr/aIxTaBL0o+nGeAgMuBu PCrt6IolNS9kWaP/pK7KwGmFSh2Mdsd+4KoPd6pTrG9HR2EcQZ6RTtsEKHbFoJHORm zjLiD2dcbtFk/Gare6vzfD/sNp4vVfEkhcdg+dsrXKqvQm6OwNhlGxqKWcvEX/9IgS Hh42fFCut3ZQOONI39R5vNiBQaE3U1u7ymhv7VogVkEz/lS0R8yVxiBSNUdX4Hrour byTZukvliBUpjJCe9glkX4fVLKuv0kj1aNNsknPJlMFdN1krxyo3HJk626yGTrgouj lVF1eVMSpxU4Q== Received: from icloud.com ([127.0.0.1]) by st14p37im-asmtp001.me.com (Oracle Communications Messaging Server 8.0.2.2.20180531 64bit (built May 31 2018)) with ESMTPSA id <0PEL001J6D4UV840@st14p37im-asmtp001.me.com>; Wed, 05 Sep 2018 16:43:43 +0000 (GMT) X-Proofpoint-Spam-Details: rule=notspam policy=default score=0 spamscore=0 clxscore=1011 suspectscore=0 malwarescore=0 phishscore=0 adultscore=0 bulkscore=0 classifier=spam adjust=0 reason=mlx scancount=1 engine=8.0.1-1707230000 definitions=main-1809050170 X-Proofpoint-Virus-Version: vendor=fsecure engine=2.50.10434:,, definitions=2018-09-05_10:,, signatures=0 Content-type: text/plain; charset=utf-8 MIME-version: 1.0 (Mac OS X Mail 11.5 \(3445.9.1\)) Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication? From: Evan Bauer In-reply-to: <1536156872692-0.post@n3.nabble.com> Date: Wed, 05 Sep 2018 09:43:41 -0700 Cc: pgsql-admin@postgresql.org Content-transfer-encoding: quoted-printable Message-id: <369474F6-47EE-414E-9B9F-A0CB6811B09C@mac.com> References: <1535435281653-0.post@n3.nabble.com> <7f636d45-36db-d87b-171a-519e21690574@anayrat.info> <1535446386936-0.post@n3.nabble.com> <394C9189-C119-4845-9D60-906C9018604C@elevated-dev.com> <1535462695414-0.post@n3.nabble.com> <1536140531829-0.post@n3.nabble.com> <03A7216C-C55D-45A2-8EEB-00E4229577E5@elevated-dev.com> <1536156872692-0.post@n3.nabble.com> To: pavan95 X-Mailer: Apple Mail (2.3445.9.1) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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 =E2=80=94 as well as give you a solid monitoring = solution for Odoop =E2=80=94 a Java web app that gives u=3Dyou almost no = production monitoring out of the box. Cheers, - Evan Evan Bauer eb@evanbauer.com +1 646 641 2973 Skype: evanbauer > On Sep 5, 2018, at 07:14, pavan95 wrote: >=20 > I just wanted to confirm if there is any other way to achieve this. = It's not > like I don't like that answer. >=20 > Anyways, thanks for answering. >=20 > Regards, > Pavan >=20 >=20 >=20 > -- > Sent from: = http://www.postgresql-archive.org/PostgreSQL-admin-f2076596.html >=20