I am looking for a script I can use to perform pg_basebackup.
I want to take basebackup (zip and tar) and also capture all WALs generated during basebackup and append them to basebackup tar. I know I can use –X flag with –s or –f . Problem is with “f” flag sometimes I find that the WAL required is deleted (archived) as mine is a large database and also activity is high. And “s” flag is not supported with tar backup.
I can record start time and end time of backup and go to my archive directory and append them to tar backup. But I am wondering if someone out there may be already doing this and willing to share the script (Unix/shell script please)
Thanks,
Murthy
Hello Murthy,
you have a lot of possibilities :
0) you could simple use more wal_keep_segments so the wall will not disappear
1) switch from tar to plain mode and use -s method
other backup method :
0) create a async streaming replica and use snapshot on the standby side