Tag Archives: postgresql
making seatmate aware of locations with postgis
Now that I’ve got the comment view more or less working, it’s time to link it up with actual trimet routes. I think we need an initial screen to show to users when they first bring up the app. I … Continue reading
pdxhash and working with spatial data using sql
Overview After analyzing the data, it would appear that we can use the geohash algorithm to geographically locate things in the Portland area by a short combination of letters and numbers. Because we only care about locations in and around … Continue reading
bulk loading shapefiles into postgis
Civicapps datasets are made available in a format called a shapefile. ESRI shapefiles are the de facto standard for distributing spatial data, but they can be tricky for those who are new to GIS. Fortunately shapefiles are an open standard with a variety of useful tools available. Continue reading
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
displaying a google maps api v3 map in a django application with geodjango and postgis
In order to create a Google Maps API v3 map with django templates and views you can use the python modules django.contrib.gis.maps and specifically django.contrib.gis.maps.google. 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
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