Re: record-based log shipping - Mailing list pgsql-general

From Greg Smith
Subject Re: record-based log shipping
Date
Msg-id Pine.GSO.4.64.0712072124580.10014@westnet.com
Whole thread Raw
In response to record-based log shipping  (SHARMILA JOTHIRAJAH <sharmi_jo@yahoo.com>)
Responses Re: record-based log shipping
List pgsql-general
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@gregsmith.com http://www.gregsmith.com Baltimore, MD

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Column pgl.transaction does not exist in 8.3 beta 4
Next
From: Alex Vinogradovs
Date:
Subject: Re: record-based log shipping