Setup a streaming replication with PostgreSQL 10

March 11, 2018
postgresql pgen

Streaming replication with PostgreSQL 10

In this post, i will explain how to setup a streaming replication with PostgreSQL 10. I will not explain how to install PostgreSQL 10 on your system.

My setup is :


Securise your communications and use SSL

This step is not mandatory but recommended. If you already have a SSL certificate, skip the first step.


Configure the master


Setup the slave

Now that your master is ready, it’s time to configure the slave.

Setup a PostgreSQL cluster with repmgr and pgbouncer

December 22, 2018
PostgreSQL replication pgen repmgr pgbouncer

Mettre en place une streaming replication avec PostgreSQL 10

March 13, 2018
postgresql pgfr

OpenBSD / PostgreSQL / Authentification

November 29, 2017
openbsd postgresql pgfr