From: | Murthy Nunna <mnunna(at)fnal(dot)gov> |
---|---|
To: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | pg_basebackup |
Date: | 2014-02-18 16:58:27 |
Message-ID: | BD7563973EF8894D905C80593EE9A4ED324A11@MAIL01.fnal.gov |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
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
From | Date | Subject | |
---|---|---|---|
Next Message | desmodemone | 2014-02-18 17:21:43 | Re: pg_basebackup |
Previous Message | Achilleas Mantzios | 2014-02-18 15:39:24 | Re: Using BSD/OS with 8.1, 8.4 and 9.3 |