Tag: tag

PostgreSQL asynchronous streaming replication where master sends WAL segments without waiting for slave acknowledgment

Data Replication Setup Using Master and Slave: PostgreSQL- III

Posted on by Sanjeeva Kumar

In last few blogs, we have seen how to automate steps required to setup Master-slave nodes. This blog would be the last in this series. Tested on PostgreSQL 11. For PostgreSQL 12+, recovery.conf is replaced by postgresql.conf settings with standby.signal file. The core replication concepts and verification steps remain the same. Until now we have Read more about Data Replication Setup Using Master and Slave: PostgreSQL- III[…]

Data Replication Setup Using Master and Slave: PostgreSQL – I

Posted on by Sanjeeva Kumar

Setting up high availability in PostgreSQL requires a master-slave replication environment where the slave takes over if the master fails. This post covers the architecture design. In next few blogs we will explore how High Availability(HA) will be setup. This is Part 1 of a 4-part series on PostgreSQL replication In this blog we will Read more about Data Replication Setup Using Master and Slave: PostgreSQL – I[…]