On Jan 7, 2008, at 7:19 AM, 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 :(
The biggest problem with what you're wanting to do here is that the
data written to the WALL archives isn't going to be at all easily
translatable into SQL statements. AFAIK, the WAL data records on-
disk file changes, i.e. it's strictly a binary mode scenario. As
someone has already suggested, if you want to learn more about
Postgres and Python, look at Skytools. I'm not just saying to use
it, read the code and, if you like, offer help with patches.
Erik Jones
DBA | Emma®
[EMAIL PROTECTED]
800.595.4401 or 615.292.5888
615.292.0777 (fax)
Emma helps organizations everywhere communicate & market in style.
Visit us online at http://www.myemma.com
---------------------------(end of broadcast)---------------------------
TIP 7: You can help support the PostgreSQL project by donating at
http://www.postgresql.org/about/donate
