Re: record-based log shipping

On Thu, 6 Dec 2007, SHARMILA JOTHIRAJAH wrote:

> Have anyone implemented or tried record-based log shipping? If so is
> there any other materials in the web other than the documentation (it
> has very few details about this)

There is an implementation of that as part of the Skytools WalMgr code:
https://developer.skype.com/SkypeGarage/DbProjects/SkyTools

Some sample interesting parts are in the walmgr.py file, in the
master_sync function, where they run

select file_name, file_offset from pg_xlogfile_name_offset(pg_current_xlog_location())

and then copy that section of the current WAL file over.

It's kind of hard to reuse any portion of their solution without adopting
the whole thing, but it's a decent approach if you're comfortable with
Python code.

--
* Greg Smith gsmith(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD