I have a master database (PostgreSQL 9.0) and I need to setup a streaming replication on a slave. Slave db can read/write and make schema level changes too which shouldn't write back to master. Can you please highlight how can I do this?
Postgresql – Setup Master-Slave replication with DML changes in Slave
postgresqlpostgresql-9.0replication
Related Question
- Postgresql – pgpool2 setup on master-slave replication using postgreql 9.1
- Postgresql – Suggested ways to route traffic between master / slave
- PostgreSQL – Preparing a Former Master to Run as Slave Again
- PostgreSQL – Transforming Streaming Replication to Cascaded Setup
- Master-Master Replication in MySQL – How to Set Up
- MariaDB – Stored Procedure in Master-Slave Replication
- Postgresql – Setup VIP for PostgreSQL Replication
Best Answer
If you only use Streaming replication, it doesn't support the write operation on the slave node. Currently, PostgreSQL doesn't support multiple master itself, If you want multiple master solution, I suggest you use PostgreSQL-XC.