Scaling Postgres Episode 87 pg_receivewal | Application Failover | pg_checksums | pgBouncer

In this episode of Scaling Postgres, we discuss the benefits of pg_receivewal, how to setup simple application failover, new pg_checksums and setting up pgBouncer.

Content Discussed

Never lose a PostgreSQL transaction with pg_receivewal
Seamless Application Failover using libpq Features in PostgreSQL
Auto Failover with PostgreSQL 12
pg_checksums 1.0 released
PgBouncer Tutorial: Installing, configuring and testing persistent PostgreSQL connection pooling
Monitoring PostgreSQL Clusters in Kubernetes
A Beginner’s Guide To Formatting Dates In SQL
PostGIS 3.0.0
Using PostgreSQL to Create an Efficient Search Engine
The RUM index and Full-Text Search Using PostgreSQL
PUsing the Built-In and Custom Ranking Algorithms of PostgreSQL for Full-Text Searches
Term Frequency Statistics in PostgreSQL Full-Text Searches