In this workshop we describe those PostgreSQL features that are most useful when implementing High Availability as well as Disaster Recovery.
There are several third party solutions that might be used to assist the user in configuring and managing PostgreSQL for those goals. However, we want to deliver a workshop which appeals to a broad audience, irrespective of which tool they might be using already, or planning to use.
We will therefore focus on understanding and using the actual PostgreSQL capabilities, giving a comprehensive picture of replication and backup/recovery techniques, and how they can be configured to achieve various degrees of Business Continuity.
We begin by introducing the Write-Ahead Log (WAL), and its applications to backup and replication. Then we discuss how replication and backup/recovery are implemented, how they can be configured to match specific requirements, and the activities required after going live, such as monitoring, cluster management, and backup retention.
Note for the committee: this workshop can be split in two separate parts (High Availability & Disaster Recovery), half day each. Each part can be delivered separately, and the common part will be repeated twice, possibly a bit shortened.