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 |
