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 1fxUKK-0007n9-IS for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 09:42:20 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxUKI-0006x0-OD for pgsql-admin@arkaria.postgresql.org; Wed, 05 Sep 2018 09:42:18 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1fxUKF-0006dA-C8 for pgsql-admin@lists.postgresql.org; Wed, 05 Sep 2018 09:42:15 +0000 Received: from n3.nabble.com ([162.255.23.22]) by magus.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1fxUKD-00083v-0K for pgsql-admin@postgresql.org; Wed, 05 Sep 2018 09:42:14 +0000 Received: from n3.nabble.com (localhost [127.0.0.1]) by n3.nabble.com (Postfix) with ESMTP id CB333EF47661 for ; Wed, 5 Sep 2018 02:42:11 -0700 (MST) Date: Wed, 5 Sep 2018 02:42:11 -0700 (MST) From: pavan95 To: pgsql-admin@postgresql.org Message-ID: <1536140531829-0.post@n3.nabble.com> In-Reply-To: <1535462695414-0.post@n3.nabble.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> Subject: Re: How to get alerted automatically whenever a table structure is changed between Publisher and Subscriber in Logical Replication? MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk 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