We're sorry but this page doesn't work properly without JavaScript enabled. Please enable it to continue.
Feedback

9.4 The Hard Way

Formal Metadata

Title
9.4 The Hard Way
Title of Series
Number of Parts
34
Author
License
CC Attribution 3.0 Unported:
You are free to use, adapt and copy, distribute and transmit the work or content in adapted or unchanged form for any legal purpose as long as the work is attributed to the author in the manner specified by the author or licensor.
Identifiers
Publisher
Release Date
Language

Content Metadata

Subject Area
Genre
Abstract
Upgrades in postgres are a challenging thing - there are several options, all with various things to consider. This presentation explains the procedure of using pg_upgrade with hard links between the old and new data directories to upgrade the master, and rsync to upgrade the slaves with minimal downtime. This method requires no additional hardware and no external replication strategies. After the what went wrong and the what went right, we will walk through a live upgrade step by step.