PostgreSQL 12 High Availability Cookbook - Third Edition

How to do it...

We simply need to produce a spreadsheet to track all of the elements of known RTO that depend on the database. We can do this with the following steps:

1. Locate an already-defined RTO SLA for each portion of the application dependent on PostgreSQL if possible.
2. If this does not exist, seek the input of major decision makers:

• VP and C-level executives involved with technology
• Product manager
• Application designers and architects
• Infrastructure team lead

3. Find an amount of time that will satisfy most or all of the above.
4. Create a new spreadsheet for RTO.
5. Create a heading row with the following columns:

• Activity
• Time (seconds)
• Count
• Total (seconds)

6. In the Total column, create the following formula:

=B2*C2

7. Create one row ...