How it works...

The primary purpose of this short recipe is to install BDR on any PostgreSQL node that will participate in a BDR cluster. Primarily, this means installing the actual packages, modifying a few configuration files, and restarting the service itself. This is a universal recipe that applies equally to any BDR node, so keep that in mind for later, as we'll be referring to it frequently.

To that end, our first step is to install the packages themselves. We will assume that you either have a BDR 60-day trial or are a 2ndQuadrant support customer, giving you direct access to their private package repositories. Note that this step also recommends installing debugging packages as well. The reason for this is very simple: BDR is complicated. ...

Get PostgreSQL 12 High Availability Cookbook now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.