PGCon2012 – Making Maps

Slides from my 2012 PGCon presentation Making your Own Maps are now available The presentation covered Common reasons people render their own maps Where to get OpenStreetMap data and how to load it into your PostGIS database How to use Tilemill to design your own map style How to render map tiles, both statically and [...]

10 years of PostgreSQL replication

February 6′th 2012 marks the 10 year anniversary of the open source release of the DBMirror replication system. DBMirror was not the first PostgreSQL replication solution to be released but it was the first one I was involved with. In the summer of 2001 I was working for Navtech System Support, an aviation software company. [...]

PostGIS Replication @ FOSS4G

My talk on PostGIS replication at FOSS4G 2011 went well. It looked like there were about 150 people in the room. Most of them had not yet deployed a PostGIS replication solution. My talk covered Slony and streaming replication. It gave an overview of different replication patterns that can crop on in the GIS space. [...]

Big Tent Conferences

This past week I attended FOSS4G in Denver, a conference run by the open-source geospatial foundation (OSGEO) that also happened to be the largest PostgreSQL conference in North America. FOSS4G is a big tent conference that attracted about 900 attendees from all over the world with over 400 of them from the United States, over [...]

Denver Day 1, What’s new in PostgreSQL 9.1

Saturday was my first full day in Denver for the OpenStreetMap State Of The Map conference. A few years ago I presented a talk at PGCon on OpenStreetMap. I have now returned the favour and presented a PostgreSQL talk (What’s new in PostgreSQL 9.1) at an OpenStreetMap conference.

PostgreSQL replication talk at FOSSLC SC2011

The slides from my PostgreSQL replication talk at FOSSLC are available here. The talk covers both Slony and Streaming replication. The key points covered in the talk are Why use replication Some common load balancing architectures 6 Simple steps to setting up Slony 5 Simple steps to setting up streaming replication I will update this [...]

New Features in Slony 2.1

Last week the Slony team released beta3 of Slony 2.1.0. I thought it would be a good idea to blog about some of the changes we have made in Slony 2.1. My personal theme for this release has been usability. I have overheard people complaining about the usability of Slony and hope that this changes [...]

September Conferences

I’m planning on attending two conferences this September in Denver. The first conference is the annual OpenStreetMap ‘State Of The Map‘ September 9-11. This year will mark the first time since I’ve been involved with OpenStreetMap that the main State Of The Map conference has been held in North America. I am looking forward to [...]

Testing streaming replication with clustertest

clustertest is the distributed testing framework that we built for testing Slony. While in Ottawa for PGCon, I modified it such that clustertest can be used to test the streaming replication features built into PostgreSQL 9.1.

C Stored Functions & The Win32 SDK

I recently wanted to build some PostgreSQL C stored functions on a Win32 machine using the Microsoft Windows SDK. I wanted to build with the Microsoft compiler (Visual C) using nmake files, but without involving the Visual Studio IDE.