Postgresql and logical replication

November 27, 2017
PostgreSQL docker replication pgen

PostgreSQL and the logical replication

In this post, I will test the new replication in PostgreSQL 10 : logical replication.

Don’t forget to read the very good documentation

Logical replication

Before the version 10 of PostgreSQL, we could only replicate the whole cluster (all the databases). As usual with PostgreSQL, everything works well but in some case, it was not very usefull (why replicate all your To of data when you only need xx Go ?).

Logical replication will allow you to replicate only certains tables. The operating principle is the following:

Warning: the database schema and DDL comands are not replicated. You will have to keep them in sync.

More informations : restrictions

Setup our lab with Docker

We will test the logical replication using Docker

The master

Now our master is ready. Let’s go to the slave.

The slave

Our logical replication is now working.

And then ?

Setup a PostgreSQL cluster with repmgr and pgbouncer

December 22, 2018
PostgreSQL replication pgen repmgr pgbouncer

Setup a streaming replication with PostgreSQL 10

March 11, 2018
postgresql pgen

OpenBSD / PostgreSQL / Authentication

November 29, 2017
openbsd postgresql pgen