pg_basebackup

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

Responses

Browse pgsql-admin by date

  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