Changing the Cluster Topology (Re-mastering and Failover) | Replicating PostgreSQL Data with Slony

Table of contents:

Summary

Summary

Slony is a powerful, well-designed, and robust replication system. Slony's user interface will surely mature over the next few years to provide a more intuitive installation, configuration, and management structure. The Slony developers are constantly adding new features and performance enhancements so keep an eye on the Slony web site (http://slony.info) for the most recent developments.

Part I: General PostgreSQL Use

Introduction to PostgreSQL and SQL

Working with Data in PostgreSQL

PostgreSQL SQL Syntax and Use

Performance

Part II: Programming with PostgreSQL

Introduction to PostgreSQL Programming

Extending PostgreSQL

PL/pgSQL

The PostgreSQL C APIlibpq

A Simpler C APIlibpgeasy

The New PostgreSQL C++ APIlibpqxx

Embedding SQL Commands in C Programsecpg

Using PostgreSQL from an ODBC Client Application

Using PostgreSQL from a Java Client Application

Using PostgreSQL with Perl

Using PostgreSQL with PHP

Using PostgreSQL with Tcl and Tcl/Tk

Using PostgreSQL with Python

Npgsql: The .NET Data Provider

Other Useful Programming Tools

Part III: PostgreSQL Administration

Introduction to PostgreSQL Administration

PostgreSQL Administration

Internationalization and Localization

Security

Replicating PostgreSQL Data with Slony

Replicating PostgreSQL Data with Slony
Overview
Requirements
Creating a Replication Cluster
Starting the Replication Daemons
Creating a Replication Set
Subscribing to a Replication Set
Changing the Cluster Topology (Re-mastering and Failover)
Summary

Contributed Modules

Index