Time: 13:30 - 16:30
Room: State Room 3
Want to provide some redundancy and availability to your PostgreSQL-based application? PostgreSQL’s Built-in Binary Replication, which has you covered. Learn what you need to know to deploy and administer it.
Built-in binary replication is conceptually simple, but the devil is in the details, and this tutorial is all about the details. We will cover all of the essentials of how to set up and configure binary replication, using hands-on exercises for some elements, including:
Materials and Vagrant/Docker test environments will be updated at the pgReplicationTutorial Github project (https://github.com/jberkus/pgReplicationTutorial) two weeks before the conference. Attendees are strongly encouraged to download it and set up the learning environment before the tutorial; time will not be given during the tutorial to do so.
Attendees are expected to be familiar with Linux and psql shell environments, as well as basic PostgreSQL administation, such as how to start, stop, and change configurations.
Attendees will leave knowing how to set up a simple replication cluster, and about the options for more complex configurations.