From: | "Saeed Ahmed (DB)" <saeed(dot)ahmed1(at)telenor(dot)com(dot)pk> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Cc: | Database Services <db(dot)is(at)telenor(dot)com(dot)pk> |
Subject: | pg_basebackup: could not get write-ahead log end position from server: ERROR |
Date: | 2018-06-08 18:27:53 |
Message-ID: | C35F307BE15BEA4585014E7B3753CC96014DCAF1A2F7@ISB-EXMB-CLUS.telenor.com.pk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Miguel Angel Sanchez Sandoval | 2018-06-08 19:56:28 | Performance problem postgresql 9.5 |
Previous Message | Tom Lane | 2018-06-08 15:41:13 | Re: High CPU load caused by the autovacuum launcher process |