All, 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 |