Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKS5B-0001ZK-Si for pgsql-admin@arkaria.postgresql.org; Thu, 30 Nov 2017 16:53:06 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1eKS5B-0000K7-0n for pgsql-admin@arkaria.postgresql.org; Thu, 30 Nov 2017 16:53:05 +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.84_2) (envelope-from ) id 1eKS5A-0000Jv-9j for pgsql-admin@lists.postgresql.org; Thu, 30 Nov 2017 16:53:04 +0000 Received: from out4-smtp.messagingengine.com ([66.111.4.28]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.89) (envelope-from ) id 1eKS57-0005gP-I8 for pgsql-admin@postgresql.org; Thu, 30 Nov 2017 16:53:03 +0000 Received: from compute7.internal (compute7.nyi.internal [10.202.2.47]) by mailout.nyi.internal (Postfix) with ESMTP id 75F2620DA1; Thu, 30 Nov 2017 11:52:59 -0500 (EST) Received: from web4 ([10.202.2.214]) by compute7.internal (MEProxy); Thu, 30 Nov 2017 11:52:59 -0500 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=hintbits.com; h= cc:content-transfer-encoding:content-type:date:from:in-reply-to :message-id:mime-version:references:subject:to:x-me-sender :x-me-sender:x-sasl-enc; s=mesmtp; bh=HL7NYqe9t8cBQtcCBy8IhJHNfm KhbOer+YFHIKlKdSY=; b=kUxBPGRgSFjCQbTBN/bokPjGm1ASMmkGdr0TyqR2BW rU2MnUNOkKjoylkJeYkMoiLizDai7gjbGdML2gqWwAVm3ayTt4fPopoYct76TkTo do0PRCT0QI97HgcXE7XhuHOh4SSR6l4K5tR10q8GfEIbPDduTUUYHIdY8etezP6U s= DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d= messagingengine.com; h=cc:content-transfer-encoding:content-type :date:from:in-reply-to:message-id:mime-version:references :subject:to:x-me-sender:x-me-sender:x-sasl-enc; s=fm1; bh=HL7NYq e9t8cBQtcCBy8IhJHNfmKhbOer+YFHIKlKdSY=; b=dVrdsr4ssEG3c+EIWnIU3i uSHFnlRNgGEJXT7Y0McpuaQTi1JfRXM+T3b6N195fSJ7y7qJuiFgmX/Hj0o8YHOC 5i8mix+MvwRcSeAqSISVGGOe0NpxVROvYo6QGGgW79ZmOQZskH98JIkEYUyh0sp7 b0Ya5crFRejX9T3wLdOHNWP/NjYrPC0mM20SAvNLNucbSrLavFgt3dTx2iv7h7Ea PBwbFlp5YiKJILDynZ2i48EmpEWtGHWK5iKVwUGzGV7lCG4ycGBcy6AO37i4AhkZ gpWUylMrPBDNBIS0p/OqoobrwPpMQSo97rV0nQKXq6kkTcCZUF+24BYjSPS483+A == X-ME-Sender: Received: by mailuser.nyi.internal (Postfix, from userid 99) id 55890BA797; Thu, 30 Nov 2017 11:52:59 -0500 (EST) Message-Id: <1512060779.2961325.1189622728.53C41299@webmail.messagingengine.com> From: Alex Kliukin To: Andres Freund Cc: Alvaro Herrera , pgsql-admin@postgresql.org MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset="utf-8" X-Mailer: MessagingEngine.com Webmail Interface - ajax-a169161c In-Reply-To: <20171130153607.tkovyfibpv4at4dc@alap3.anarazel.de> References: <1511966240.1459861.1188109744.2D26AD08@webmail.messagingengine.com> <20171129232243.vk5ik5szknppo3it@alvherre.pgsql> <20171130004107.j2ve7qn2ene7fqhm@alap3.anarazel.de> <1512038669.1366070.1189170512.3D900EE2@webmail.messagingengine.com> <20171130153607.tkovyfibpv4at4dc@alap3.anarazel.de> Date: Thu, 30 Nov 2017 17:52:59 +0100 Subject: Re: 'replication checkpoint has wrong magic' on the newly cloned replicas List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Thu, Nov 30, 2017, at 16:36, Andres Freund wrote: > Hi, > > On 2017-11-30 11:44:29 +0100, Alex Kliukin wrote: > > max_replication_slots is 5 and logical replication is not used > > altogether there. > > Can you show the results of > SELECT * FROM pg_replication_origin; > SELECT * FROM pg_replication_origin_status ; SELECT * FROM pg_replication_origin; roident | roname ---------+-------- (0 rows) SELECT * FROM pg_replication_origin_status ; local_id | external_id | remote_lsn | local_lsn ----------+-------------+------------+----------- (0 rows) -- Sincerely, Alex