PostgreSQL High Availability Cookbook - Second Edition

How to do it...

We simply need to produce a hardware spreadsheet to track our purchase needs. We can do that with the following steps:

1. Create a new spreadsheet for parts and details.
2. Create a heading row with the following columns:
   • Type
   • Capacity
   • Supplier
   • Price
   • Count
   • Total cost
3. Create a new row for each type of the following components:
   • Chassis
   • CPU
   • Hard Drive (3.5")
   • Hard Drive (2.5")
   • Hard Drive (SSD)
   • Motherboard
   • Network Card
   • Power Supply
   • RAID Controller
   • RAM
   • SAN
4. In the Chassis row, under the Total cost column, enter the following formula: =D2*E2
5. Copy and paste the formula into the Total Cost column for all the rows we created. The end result should look something like the following screenshot: