~/talk

PostgreSQL The Hard Way

on YouTube 32m
Talkat PGConf Silicon Valley 2016 · 2016-11-14..11-16· [databases]

speaker

name:James Miller
links:none on file

resources

video:https://youtu.be/oQqGz-LL950
slides:none on file

summary

Upgrades PostgreSQL 9.2 to 9.4 across seven clusters (37 servers, largest 667 GB) aiming for four‑hour maintenance windows by using PG upgrade with hard links, then rsync --size-only to copy only changed files to slaves, plus PG_START_BACKUP to avoid recovery traps. Tests take six weeks and reveal rsync hard‑link ordering issues with nonstandard mount points, config‑management drift, one slow slave, and two failed disks on the day; outcome: most clusters finish within windows but rebuild stale slaves if possible.

AI-written summary · about

chapters (4)

  1. 0:00Start
  2. 16:29Configuration Management
  3. 22:43Hardware Failure
  4. 26:46Summary

related talks

~/search
type to search 6,249 conferences, 138,987 speakers and 185,172 talks
~/help
cmdctrl k
search every conference, speaker and series
/
focus the filter search
h
home
c
conferences
s
speakers
e
series
t
light / dark — the status bar button does the same
?
this help
esc
close this, then clear every filter — or just the search, while you are typing in it

Ignored while you are typing. Pages without a filter rail have no search to focus.