Using pg_rewind for differential backup

From: Sameer Kumar <sameer(dot)kumar(at)ashnik(dot)com>
To: PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org>, heikki(dot)linnakangas(at)iki(dot)fi
Subject: Using pg_rewind for differential backup
Date: 2014-11-27 12:39:12
Message-ID: CADp-Sm7D4dN6Ntjt_-4xiv17C0TVOT19HMUjSDJnX9-yextJFQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Can we tweak pg_rewind to take differential backups in PostgreSQL?

I was wondering can we hack the pg_rewind code to print the details of the
file which have been modified compared to a target server.
The list output can then be used for taking differential backups.

Or perhaps we can add an option/switch in pg_rewind --action

--action=print ---> would print the files which have changed
--action=sync ---> would sync them
--action=copy ---> with this option I can specify an additional optino
--target-dir where I can copy the files which have changed blocks

pg_rewind-
https://github.com/vmware/pg_rewind

Best Regards,

*Sameer Kumar | Database Consultant*

*ASHNIK PTE. LTD.*

101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533

M: *+65 8110 0350 <%2B65%208110%200350>* T: +65 6438 3504 | www.ashnik.com

*[image: icons]*

[image: Email patch] <http://www.ashnik.com/>

This email may contain confidential, privileged or copyright material and
is solely for the use of the intended recipient(s).

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2014-11-27 13:13:30 Re: What exactly is our CRC algorithm?
Previous Message Mats Erik Andersson 2014-11-27 12:32:44 pg_isready: Missing translation macros.