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 <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fdFWG-0006it-0o
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jul 2018 13:51:00 +0000
Received: from localhost ([127.0.0.1] helo=malur.postgresql.org)
	by malur.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <pgsql-admin-owner+archive@lists.postgresql.org>)
	id 1fdFWD-0006J5-Jq
	for pgsql-admin@arkaria.postgresql.org; Wed, 11 Jul 2018 13:50:57 +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 <ktm@aart.rice.edu>)
	id 1fdFWD-0006Iy-8Q
	for pgsql-admin@lists.postgresql.org; Wed, 11 Jul 2018 13:50:57 +0000
Received: from aart.rice.edu ([168.7.56.48])
	by makus.postgresql.org with esmtp (Exim 4.89)
	(envelope-from <ktm@aart.rice.edu>)
	id 1fdFWA-0003Uu-96
	for pgsql-admin@lists.postgresql.org; Wed, 11 Jul 2018 13:50:55 +0000
Received: by aart.rice.edu (Postfix, from userid 18612)
	id 9C3F7427F28E; Wed, 11 Jul 2018 08:50:53 -0500 (CDT)
Date: Wed, 11 Jul 2018 08:50:53 -0500
From: Kenneth Marshall <ktm@rice.edu>
To: Mariel Cherkassky <mariel.cherkassky@gmail.com>
Cc: Achilleas Mantzios <achill@matrix.gatewaynet.com>,
	pgsql-admin@lists.postgresql.org
Subject: Re: wal exist in slave but getting err requested WAL segment has
 already been removed
Message-ID: <20180711135053.GU27560@aart.rice.edu>
References: 
 <CA+t6e1kW7vihQesZhwToxa2HQ1zMj5Jr=mM=Rh0cXC+SofkKig@mail.gmail.com>
 <9f931b88-725f-7020-ebb2-a2446b7ff9e6@matrix.gatewaynet.com>
 <CA+t6e1ng9Jx8quMWimfGKyTuaSiL3azj6woDEeix-r1mtgzP1w@mail.gmail.com>
 <49a8b5fc-e181-ff57-ea51-f9a2753b4dbc@matrix.gatewaynet.com>
 <CA+t6e1n==PHG525gTGAPmx+W8YC4khnT4aL6zeke6FH51q-ECA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: 
 <CA+t6e1n==PHG525gTGAPmx+W8YC4khnT4aL6zeke6FH51q-ECA@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
List-Id: <pgsql-admin.lists.postgresql.org>
List-Help: <https://lists.postgresql.org/manage/>
List-Subscribe: <https://lists.postgresql.org/manage/>
List-Post: <mailto:pgsql-admin@lists.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@lists.postgresql.org>
List-Archive: <https://www.postgresql.org/list/pgsql-admin>
Precedence: bulk

On Wed, Jul 11, 2018 at 04:44:24PM +0300, Mariel Cherkassky wrote:
> Yes i can see its content. However in the end of its content I'm getting
> the next msg :
> pg_xlogdump: FATAL:  error in WAL record at 2E61/BDF59950: invalid magic
> number 0000 in log segment 0000000000002E61000000BD, offset 16105472
> Maybe this is the reason behind it ?
> 

Hi Mariel,

I do not know if this applies to your case, but 9.6.9 has this
in the release notes:

Fix a corner case where a streaming standby gets stuck at a WAL continuation record (Kyotaro Horiguchi)

Regards,
Ken