Re: Error when running pg_basebackup

On 12/10/2016 21:31, Campbell, Lance wrote:
> PostgreSQL – 9.5.4
>
> Command that is being executed:
>
> pg_basebackup --host=localhost --xlog --gzip --write-recovery-conf
> --format=t --pgdata=${BACKUPS_HOME}/${BACKUP_DATE_TIME}
>
>
>
> Error message that appears at the very end of pg_basebackup:
>
> pg_basebackup: could not get transaction log end position from server:
> ERROR: requested WAL segment 00000001000001CD00000055 has already been
> removed
>
>
> How can I prevent this error from occurring?
>

You could use -X stream instead of --xlog (which is an alias for -X
fetch). This consumes two wal senders instead of one, but greatly
reduce the probability of having this error.

The only way to really prevent this error is using replication slots,
but the support for pg_basebackup is only available in 9.6.

--
Julien Rouhaud
http://dalibo.com - http://dalibo.org