From: | Greg Smith <gsmith(at)gregsmith(dot)com> |
---|---|
To: | SHARMILA JOTHIRAJAH <sharmi_jo(at)yahoo(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: record-based log shipping |
Date: | 2007-12-08 02:38:00 |
Message-ID: | Pine.GSO.4.64.0712072124580.10014@westnet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)gregsmith(dot)com http://www.gregsmith.com Baltimore, MD
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Vinogradovs | 2007-12-08 03:02:39 | Re: record-based log shipping |
Previous Message | Tom Lane | 2007-12-08 01:21:08 | Re: Column pgl.transaction does not exist in 8.3 beta 4 |