PostgreSQL backup strategies
Update 30-Jan-2023: Looks like this barren post that originally linked to a 9 years Youtube video is setting itself up to track the evolution of PostgreSQL backup good practices over time, so we can see what changes and what remains valid. Both talks are from Magnus Hagander, a core contributor to PostgreSQL.
2016:
2013: