How to do it...

Try to answer all of these questions:

  • Who uses the database? For each type of user, answer these questions:
    • When does this user access the database?
    • What is the maximum query timeout they will tolerate?
    • Will the user lose money during an outage?
    • Is the user likely to return later?
    • Should this user be included in maintenance notifications?
    • Should this user be included in emergency notifications?
  • Can we get the user to agree to or even sign the SLA?
  • What uptime percentage is expected? 99 percent? 99.9 percent? 99.99 percent? More?
  • What are the company's official business hours?
  • When should notifications be sent?
  • How long can the platform operate without the database?
  • How long should regular maintenance windows be?
  • How often ...

Get PostgreSQL High Availability Cookbook - Second Edition 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.