Setting Up Streaming Replication With Postgresql
4 minute read Published:
A new blog post by me.
Introduction In PostgreSQL 9.0 and up it is possible to setup streaming replication (SR). When doing this, it will replicate all databases from one server to an other.
To be able to do this the following requirements have to be met:
Same achritecture and number of bits; Same major/minor? version should be used on both systems. (so 9.1.x with 9.1.y = major); Same OS or psql source. The steps to setup SR on the PostgreSQL wiki ?