O'Reilly logo

PostgreSQL 9 Administration Cookbook by Hannu Krosing, Simon Riggs

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Selective replication using Londiste

Londiste is part of the Skytools suite of software, produced by and used by Skype for their production transactional databases. Londiste is a replication system built on top of a generic event-queuing system named PgQ (pronounced as pg-queue), a PostgreSQL extension module.

It's simple, easy, and robust.

One of the most important features is that Londiste achieves eventual consistency between Master and Standby in a relaxed manner, ensuring that operations on the Master are lock-free.

Getting ready

If you haven't read the recipes on Replication Concepts and Replication best practice at the start of this chapter, please go and read them now. Replication is complex, and even if you think "no problem, I know that", ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required