PostgreSQL High Performance Cookbook

Setting up a Postgres-XL cluster

Here in this recipe, we are going to set up a Postgres XL cluster, which is a scalable PostgreSQL cluster, to solve the big data processing challenges.

Getting ready

Postgres-XL is a horizontally scalable open source cluster, which has a set of individual dedicated components to scale PostgreSQL to multiple nodes. Postgre-XL (extensible lattice) gives us more convenience in distributing the data across the nodes or replicating the data across the nodes.

How to do it...

Note that:

node1 -- ec2-54-164-174-117.compute-1.amazonaws.com -- 172-30-1-154
node2 -- ec2-54-152-235-194.compute-1.amazonaws.com -- 172-30-1-155
node3 -- ec2-54-165-7-151.compute-1.amazonaws.com -- 172-30-1-156
node4 -- ec2-54-152-210-130.compute-1.amazonaws.com ...