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 master-slave streaming replication configuration showing postgresql.conf and recovery.conf parameters with WAL streaming between nodes

Data Replication Setup Using Master and Slave: PostgreSQL – II

Posted on by Sanjeeva Kumar

This is Part 2 of our PostgreSQL streaming replication configuration series. In this post, we configure the master and slave nodes — covering every postgresql.conf and recovery.conf parameter you need for streaming replication. Tested on PostgreSQL 11. Note: Starting from PostgreSQL 12, recovery.conf has been removed. Replication parameters now go directly into postgresql.conf and a Read more about Data Replication Setup Using Master and Slave: PostgreSQL – II[…]