pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: "C." Bergström <cbergstrom@netsyncro.com>
To: pgsql-sql@postgresql.org
Subject: Re: reading WAL files in python
Date: Mon, 07 Jan 2008 15:05:28 +0100
Message-ID: <1199714728.11354.309.camel@chaos> (raw)
In-Reply-To: <478226FB.6030306@fmed.uba.ar>
References: <478226FB.6030306@fmed.uba.ar>


On Mon, 2008-01-07 at 10:19 -0300, Gerardo Herzig wrote:
> Hi all. Im having some fun trying to write my own replication system 
> using python. I will use the postgres own WAL archiving to write the 
> files,  then my app will read them and do some stuff. As im not a C 
> programmer, im stuck in the mission of reading the binary files.
> 
> I guess im needing to know the internals of how wals archives are, how 
> big the buffer has to be, in order to have a complete sql command.
> 
> Can someone point some advice?
> I was trying to understad src/backend/access/transam/xlog.c, but seems 
> too difficult to me :(
> 

imho you can save yourself a lot of time by taking a look at skytools[1]
as it may be more along the lines of what you're trying to accomplish
anyway.

Cheers,

./C

[1] https://developer.skype.com/SkypeGarage/DbProjects/SkyTools




view thread (5+ messages)  latest in thread

Message-ID: <1199714728.11354.309.camel@chaos>
Permalink:  ../1199714728.11354.309.camel@chaos/
Also on:    postgresql.org/message-id/1199714728.11354.309.camel@chaos

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: cbergstrom@netsyncro.com
  Subject: Re: reading WAL files in python
  In-Reply-To: <1199714728.11354.309.camel@chaos>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox