Hans-Jürgen Schönig gives us a list:
This document explains which options are available and which problems one can solve with PostgreSQL. We have listed the most common setups and some of the most common recommendations.
Read on for three common scenarios.