Monthly Archives: March 2010
geocoding and spatial database queries using python with django and postgis
Python is an excellent language for developing GIS applications. It’s very easy to create a web service that queries a spatial database and returns a result. Sometimes that sort of thing is called a location based service. They are common … 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
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