9 High availability bad practices
This chapter covers
- Neglecting proper backup hygiene
- Forgoing PostgreSQL recovery features
- Being unprepared for database failure
- Using the wrong tools for the job
Another thing PostgreSQL has gained a reputation for in the industry is its famed resilience. However, this resilience is predicated upon following the best practices and using the proper tools. Dangerous situations can arise if complacency takes hold on account of "Postgres being a resilient database" and High Availability (HA) is relegated to an afterthought. Instead, HA should be central to the deployment plan of any production database cluster.
When we refer to High Availability in this chapter we are encompassing the techniques and methods that can keep your database accessible to its users throughout failure scenarios, from minor to catastrophic, and also allow it to recover from these failures. The goal of HA is to guarantee the minimum amount of downtime or data loss — being fully aware that the requirements and acceptable limits can differ for each organization.