Take the 2-minute tour ×

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?

share|improve this question
add comment

1 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.

share|improve this answer
add comment

Your Answer


