O'Reilly logo

PostgreSQL Replication by Hans-Jürgen Schönig, Zoltan Böszörmenyi

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Configuring a simple cluster

In this chapter, we want to set up a cluster consisting of three (Datanodes). A Coordinator and a Global Transaction Manager will be in charge of the cluster. For each component, we have to create a directory:

hs@vm:~/data$ ls -l
total 24
drwx------  2 hshs 4096 Jun 13 15:56 gtm
drwx------ 13 hshs 4096 Jun 13 15:54 node1
drwx------ 13 hshs 4096 Jun 13 15:55 node2
drwx------ 13 hshs 4096 Jun 13 15:55 node3
drwx------ 13 hshs 4096 Jun 13 15:55 node4

Keep in mind that, to make life simple, we will set up the entire cluster on a single server. In production, you would logically use different nodes for those components, otherwise there is no point in using Postgres-XC.

Creating the GTM

In the first step, we have to initialize ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required