Browsed by
Tag: postgres replication status

How to set up streaming replication in Postgres 9.4 on Ubuntu

How to set up streaming replication in Postgres 9.4 on Ubuntu

One of my first projects at my new gig was to set up streaming replication on Postgres 9.4 database server. Replication is a handy way of mirroring data stored in postgres across several servers. It's useful for scaling reads to a database cluster (in our case, a driving force for the change was to make sure our nightly backups were not running from the master server). The first thing to do is Read the article >>