PostgreSQL Database and Linux System Administrator since 2010. Worked on a large number of servers in the Belgian health-care area, deploying software upgrades, handling database backups and keeping systems up-and-running. Living near Mons (BE), working for Dalibo as PostgreSQL DBA since July 2017. Enjoying contributing to the community since then.
Streaming Replication can be used to setup a replicated PostgreSQL cluster, with one or more standby servers ready to take over operations if the primary server fails. This feature relies on the Write Ahead Logs, aka WALs, and offers a lot of possibilities. The talk will summarize for beginners what WALs are, how does the Streaming Replication works, give some advices and best practices.