pg_basebackup: could not get write-ahead log end position from server: ERROR

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

Responses

Browse pgsql-admin by date

  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