Tag Archives: bucardo

deploying bucardo and solving a schema mismatch problem

In the process of deploying bucardo 4.4.0 to replicate a fairly large django database using postgresql 8.4, I ran into a tricky issue. Although I knew for certain that the database schemas were identical, bucardo still complained about a mismatch in the default value for the first table’s primary key column. Continue reading

Posted in technology | Tagged , , , , | 4 Comments

installing bucardo the hard way

It would seem that the bucardo_ctl installer script for version 4.4.0 has some problems. I spent a little time trying to fix the script, but it was too much of a pain. I found a great write up by Richard … Continue reading

Posted in technology | Tagged , , , , | 4 Comments

installing bucardo for multi-master postgres database replication

In my quest for postgres replication/clustering nirvana I’ve played with pgpool, slony, rubyrep and now bucardo. Our requirements are painless bidirectional synchronization between two postgresql databases that serve a django application. Bucardo seems awesome, but there are some problems with … Continue reading

Posted in technology | Tagged , , , , , , | Leave a comment

using rubyrep to replicate a postgresql database on ubuntu 9.10 (karmic koala)

Update: I was mistaken about rubyrep’s ability to support continuous replication.  See my new post for an update. For my current project, we need to replicate a postgresql 8.4 database between several sites.  We are looking at bucardo and rubyrep. … Continue reading

Posted in technology | Tagged , , , , | 2 Comments