Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etkwH-00066n-9n for pgsql-admin@arkaria.postgresql.org; Thu, 08 Mar 2018 02:05:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1etkwF-0006pA-MT for pgsql-admin@arkaria.postgresql.org; Thu, 08 Mar 2018 02:05:47 +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 1etiPT-0005XU-Ex for pgsql-admin@lists.postgresql.org; Wed, 07 Mar 2018 23:23:47 +0000 Received: from mail70c0.megamailservers.com ([69.49.121.90]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1etiPP-000506-7v for pgsql-admin@lists.postgresql.org; Wed, 07 Mar 2018 23:23:45 +0000 Received: from mail70c0.megamailservers.com (localhost [127.0.0.1]) by mail70c0.megamailservers.com (8.14.9/8.13.1) with ESMTP id w27NNcS2009304 (version=TLSv1/SSLv3 cipher=DHE-RSA-AES256-GCM-SHA384 bits=256 verify=NO) for ; Wed, 7 Mar 2018 18:23:38 -0500 Received: (from webmail@localhost) by mail70c0.megamailservers.com (8.14.9/8.12.2/Submit) id w27NNcvr009303 for pgsql-admin@lists.postgresql.org; Wed, 7 Mar 2018 18:23:38 -0500 Message-Id: <201803072323.w27NNcvr009303@mail70c0.megamailservers.com> MIME-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: quoted-printable To: pgsql-admin@lists.postgresql.org CC: Subject: How to monitor logical replication initial sync? From: Doug Gorley X-Image-Url: https://webmail.internethosting.com/api/storage/doug@gorley.ca/profile/picture Date: Wed, 07 Mar 2018 18:23:38 -0500 X-CTCH-RefID: str=0001.0A020206.5AA0747B.0001,ss=1,re=0.000,recu=0.000,reip=0.000,cl=1,cld=1,fgs=0 X-CTCH-VOD: Unknown X-CTCH-Spam: Unknown X-CTCH-Score: 0.000 X-CTCH-Rules: X-CTCH-Flags: 0 X-CTCH-ScoreCust: 0.000 X-CSC: 0 X-CHA: v=2.2 cv=KsM94SeN c=1 sm=1 tr=0 a=WkljmVdYkabdwxfqvArNOQ==:117 a=IkcTkHD0fZMA:10 a=ikZSrtty1KYA:10 a=v2DPQv5-lfwA:10 a=LCuFsq3HAAAA:8 a=thEc1CFyIB6PAqPpDHMA:9 a=QEXdDO2ut3YA:10 a=oAtGp7TVuj6DzOd2i_nH:22 List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk Good day, How does one monitor the status or progress of an initial sync under logica= l replication? For example: * I create a publication in database db_pub * I create a subscription in database db_sub * In 15 minutes I want to check an see that the initial sync is N% complete Is it possible to tell when the initial sync is complete, or better yet, ho= w complete it is? Thanks, --- Doug Gorley | doug@gorley.ca