Re: PG13 pg_receivewal failing

On 2020/09/25 5:51, Grigory Smolkin wrote:
> Hello!
> 
> I`ve encountered the following error when trying to stream WAL via pg_receivewal:
> 
> pg_receivewal -p 11770 --synchronous -D /wal/node -v
> pg_receivewal: starting log streaming at 0/1000000 (timeline 1)
> pg_receivewal: error: unexpected termination of replication stream: ERROR:  requested WAL segment
000000010000000000000001has already been removed
 
> pg_receivewal: disconnected; waiting 5 seconds to try again
> 
> 
> Is there something awry with start position calculation, or am I doing something wrong?

I guess that 000000010000000000000001.partial file remained in /wal/node
and pg_receivewal used 0/1000000 as the starting WAL position.

Regards,

-- 
Fujii Masao
Advanced Computing Technology Center
Research and Development Headquarters
NTT DATA CORPORATION