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
Attachment:
signature.asc
Description: PGP signature