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@xxxxxxxxxxxxx http://www.gregsmith.com Baltimore, MD
---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend
