Dear Team,
1)Whilst taking full backup via pg_basebackup I have facing below error. Backup is schedule via cronjob.
================================================================================
****** Full Backup of posgresql database started Fri Jun 8 20:40:36 PKT 2018.
080618204036
pg_basebackup: initiating base backup, waiting for checkpoint to complete
pg_basebackup: checkpoint completed
pg_basebackup: write-ahead log start point: 43/400252F8 on timeline 1
17624153/17624153 kB (100%), 2/2 tablespaces
pg_basebackup: could not get write-ahead log end position from server: ERROR: requested WAL segment 000000010000004300000040 has already been removed
pg_basebackup: removing data directory "/db01/pgdata/hot_backup/080618204036"
2)Also after complete backup I have to manually delete the wal archive files using pg_archivecleanup. Is there any way to automatically delete after full backup is complete and wal archive are no longer required.
pg_archivecleanup -d /db01/wal_archive 00000001000000390000000A
Kindly let me know how to rectify.
pg_basebackup -z -X fetch --progress -v --format=t -D /db01/pgdata/hot_backup/$DD --no-password
Current Version:
version
---------------------------------------------------------------------------------------------------------
PostgreSQL 10.1 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.4.7 20120313 (Red Hat 4.4.7-18), 64-bit
LINUX : .10.0-327.el7.x86_64
Regards,
Saeed Ahmed