Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ldUB7-0004wD-9M for pgsql-general@arkaria.postgresql.org; Mon, 03 May 2021 08:43:45 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1ldUB5-0008D8-6Z for pgsql-general@arkaria.postgresql.org; Mon, 03 May 2021 08:43:43 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1ldUB4-0008D1-VO for pgsql-general@lists.postgresql.org; Mon, 03 May 2021 08:43:42 +0000 Received: from mail-wr1-x42d.google.com ([2a00:1450:4864:20::42d]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1ldUB0-0000oG-5L for pgsql-general@lists.postgresql.org; Mon, 03 May 2021 08:43:41 +0000 Received: by mail-wr1-x42d.google.com with SMTP id m9so4647883wrx.3 for ; Mon, 03 May 2021 01:43:38 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=cybertec-at.20150623.gappssmtp.com; s=20150623; h=message-id:subject:from:to:date:in-reply-to:references:user-agent :mime-version:content-transfer-encoding; bh=MwGm8DHBfx9hTQgOqrGlFlON2J4qfTeoUzNLDyjt/lM=; b=CNeqP174K7Mt2/4DFQJs/dhcP15HSuDNd20WDGMsEMKpd6o1NxQ9TffgQvNAglsw9A LuEbWgNH6gG2CWNiByQSN7VhyvbikRqej+DbhDi5kCQBRivS+rzLB7xYnWPifc+8ivOr vw1mQYuXA01688i/CFuVpNJVQZK8EM6af6vNLvVpt0bZp6ubX21eUQ/93I9N/WK09tcD jWy9eTYt0hDvPPhgHuF+/W53UMZe+93POJ5Zl2+C49M+fnKKRV8AMBgPtK/q7j2hP1Ti 5HQRyoKaB2t+XcCdLlnPFnUrzFCgo2nJ+lQg2eoUMJC2Pg3UcJ9IJ4OzEpwvpIizbuHN rbcQ== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:message-id:subject:from:to:date:in-reply-to :references:user-agent:mime-version:content-transfer-encoding; bh=MwGm8DHBfx9hTQgOqrGlFlON2J4qfTeoUzNLDyjt/lM=; b=G3ROqnGcV4kqwSkXiq4O57gymCSqqpU20I/0XwvXL0u7OnTWwQh9LiXrfz0q83qR3Y sHjHrIbT6maGw59hlwy9GV4Qye2cOJ5D17Je4y94+oDd2wOmDENb1zjiR04z94QqGo3c J8KVvXWO9rw6AouXydAV8/XDzLu3JvOqsl2PquH06oMd8S4pXIUj0/uC4hxa9ssk/smx sXK2TR3ebOam1s8LNW0dFx+SMLN/vzowuPeCP6Wu8Y+f98TQ/Q7FyTqdRgnGKPrKchiN 6rRfT0w+7vyBL0Q7kJ5WWcNQ0e7egRH1PtWuJtC8O1VaiJ2giQIiYGEfvwxQ9ZNi7xM1 4VeQ== X-Gm-Message-State: AOAM533L/9IyUNkay4P7F5ecyBdRi3GW0oKVIHrX9gjESVJRruj6YYs8 PXM13dN0Y/OqMfDp9hLTxhbPEA== X-Google-Smtp-Source: ABdhPJwPYqlbz241aNAWnogF/4jZqqXAemEtoXJH3Sh1CA2Vq7Gkbe6VRxwdWncAS5T9pR3T/OVY5g== X-Received: by 2002:a5d:6352:: with SMTP id b18mr23725127wrw.76.1620031416855; Mon, 03 May 2021 01:43:36 -0700 (PDT) Received: from localhost.localdomain (217-149-172-121.nat.highway.telekom.at. [217.149.172.121]) by smtp.gmail.com with ESMTPSA id j13sm11527128wrw.93.2021.05.03.01.43.36 (version=TLS1_3 cipher=TLS_AES_256_GCM_SHA384 bits=256/256); Mon, 03 May 2021 01:43:36 -0700 (PDT) Message-ID: <2f06177afc2acb33b4dc3ba70cc6c52af9aeefdc.camel@cybertec.at> Subject: Re: "invalid contrecord" error on replica From: Laurenz Albe To: Adrien Nayrat , JOULAUD =?ISO-8859-1?Q?Fran=E7ois?= , "pgsql-general@lists.postgresql.org" Date: Mon, 03 May 2021 10:43:33 +0200 In-Reply-To: <1f1da31b-6b39-55e5-a9b0-487068d5b225@anayrat.info> References: <20190701161014.24jej3zt7tlhu6a2@fjo-extia-HPdeb.example.avalenn.eu> <1f1da31b-6b39-55e5-a9b0-487068d5b225@anayrat.info> Content-Type: text/plain; charset="UTF-8" User-Agent: Evolution 3.36.5 (3.36.5-2.fc32) MIME-Version: 1.0 Content-Transfer-Encoding: 7bit List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk On Sun, 2021-05-02 at 22:43 +0200, Adrien Nayrat wrote: > LOG: started streaming WAL from primary at AA/A1000000 on timeline 1 > FATAL: could not receive data from WAL stream : ERROR: requested starting > point AA/A1000000 is ahead of the WAL flush position of this server AA/A0FFFBE8 You are trying to stream from a server whose WAL position is *behind* your own. That cannot work. Yours, Laurenz Albe -- Cybertec | https://www.cybertec-postgresql.com