Thanks to Streaming-Only Remastering, PostgreSQL 9.3 has been a boon to high-availability setups and maintenance  You can re-arrange your re...

Two years ago I wrote a post explaining how to determine relative log position in order to determine which replica was furthest ahead .  Thi...

One of the things we've been lacking in Postgres world for a while is a utility which can smoothly handle auto-failover in a replicated ...

Cascading replication is a 9.2 feature which allows you to replicate through a chain of replicas.  The master replicates to replica1, which ...

A few of our clients run on the Joyent cloud.  Uniquely, Joyent runs SmartOS, an Illumos (i.e. OpenSolaris) distribution, which is the def...

Here's a common situation for PostgreSQL binary replication setups with multiple replicas: the master is down, and you want to promote t...

Canonical staff member Robert Collins has a nice blog about how Launchpad reduced downtimes for agile schema deployment from an hour down to...

As I mentioned, I'm back to writing for Linux Weekly News.  My latest, a summary of interesting developments at pgCon, is now up.  Note...