A project called slony1 has a bolt-on replication toolset for PostgresSQL 7.x – it uses a daemon and a set of stored procedures to replicate table data across clusters.
The list of tables and sequences it replicates has to be hardwired (hurrah for introspection) and it needs a whole nest of perl(1) support tools to generate configs but it does what it says on the tin.
I found these notes hugely helpful in setting things up.
Leave a Reply
Recent articles
- Getting paranoid about ssh-agent
(Wednesday, 09. 1. 2010 – 1 Comment) - cron
(Wednesday, 02. 24. 2010 – 6 Comments) - SOAP in unexpected “actually, quite easy” incident.
(Wednesday, 09. 30. 2009 – No Comments) - ipmitool for OSX
(Tuesday, 09. 29. 2009 – No Comments)
Archives
- September 2010
- February 2010
- September 2009
- August 2009
- January 2009
- September 2008
- August 2008
- July 2008
- May 2008
- April 2008
- February 2008
- January 2008
- November 2007
- October 2007
- September 2007
- August 2007
- December 2006
- November 2006
- August 2006
- June 2006
- May 2006
- March 2006
- February 2006
- January 2006
- December 2005
- November 2005
- October 2005