Configuring replication between two databases is considered to be a best strategy towards achieving high availability during disasters and provides fault tolerance against unexpected failures. PostgreSQL satisfies this requirement through streaming replication. We shall talk about another option called logical replication and logical decoding in our future blog post. Streaming replication works on log shipping. [&]

The post Setting up Streaming Replication in PostgreSQL appeared first on Percona Database Performance Blog.

https://www.percona.com/blog/2018/09/07/setting-up-streaming-replication-postgresql/