Tag Archives: replication
rubyrep and postgresql replication roundup
While replication might not be tightly integrated into postgresql at the moment, we are lucky to have a variety of tools. Each one has different qualities and meets different needs. SlonyII is mature and easy enough to implement, but it … Continue reading
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
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
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