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 ?expect? that the source code is used to setup the PostgreSQL installations. In this post Debian packages of postgresql-9.1 will be used to setup SR .