Tag: tag

PostgreSQL synchronous master-slave replication — master waits for slave ACK via remote_apply

Data Replication Setup Using Master and Slave: PostgreSQL- IV

Posted on by Sanjeeva Kumar

In this final blog of our PostgreSQL synchronous replication setup series, we close the loop on Master-Slave replication — and we save the best for last. Through the previous three blogs, we built our foundation, configured the async node, and watched streaming replication come alive. Async worked beautifully — but async also means the master Read more about Data Replication Setup Using Master and Slave: PostgreSQL- IV[…]

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[…]