WAL Shipping Integration

Write Ahead Log Shipping Overview

PostgreSQL has the ability to ship write ahead logs to another database. This database is running in recovery mode with the pg_standby utility applying the write ahead logs.

Goal

• The PostgreSQL agent should support the log shipping functionality as a replacement for shared storage
• The PostgreSQL agent should support the replication between two different clusters or between two different PostgreSQL failover resource within one cluster

Status

• 08 Jan 2008 Design document posted  
• 23 Jan 2008 Webrev available
• 12 Feb 2008 New webrev available, the new changes enables the ssh based WAL shippping, to be secured with passphrases.
• ß7 April 2008 Experimental package and single node cluster cheatsheet posted.
• 22 April 2008 New webrev available, the feedback from the code review was incorporated. 
• 27 August 2008 As far as Open HA Cluster is concerned the project work is done.

Documentation
*Design Document
*Single node cluster cheatsheat

Experimental download

The generic data service (GDS) coding template is released under the Common Development and Distribution License (CDDL) Version 1.0.

Experimental package

Contacts
ulherr (Detlef Ulherr) main contact