Re: Reeving an error while taking the backup using "pg_basebackup" utility.

On Tue, Aug 28, 2018 at 07:19:12AM +0530, Raghavendra Rao J S V wrote:
> pg_basebackup: could not get transaction log end position from server:
> FATAL: requested WAL segment 00000001000002850000008F has already been
> removed
>
> Please guide me why and how to handle this error. Do you want me to change
> any of the option in my pg_basebackup command let me know.

This means that while taking a backup, a checkpoint has come in and has
recycled past segments. Lack of luck it is, as depending on the load
you may see such failures. One way to correct the problem would be to
take a base backup without WAL segments included and with a WAL archive
used by the base backup taken. A second is to use a physical
replication slot which guarantee the presence of the wanted segments.
--
Michael