Re: Error when running pg_basebackup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux