Recently, I have come upon the need to deploy a high-availability/performance postgres cluster, and I looked into various replication solutions. Of the ones I saw, Streaming Replication was the easiest to set up, fairly performant and a good fit for what we wanted to do, and it’s built into postgres 9.0+.
Unfortunately, checking the documentation and howtos, I gained little insight into how it works. There are plenty of detailed guides on how to set it up, but none explain how exactly it works, so it was a bit of a black box for me. Fortunately, the guys in #postgresql are extremely helpful, and quickly explained to me the specifics of replication, which I am going to post here for