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.

Mettre en place une streaming replication avec PostgreSQL 10

March 13, 2018
postgresql pgfr

OpenBSD / PostgreSQL / Authentification

November 29, 2017
openbsd postgresql pgfr

OpenBSD / PostgreSQL / Authentication

November 29, 2017
openbsd postgresql pgen