Menu

Configuration

Koichi Suzuki

How to configure Postgres-XC

Postgres-XC is very flexible and you will find there are many other configurations you can use. This page gives only simple example. With real server, you can configure Postgres-XC with more than ten servers.

This page describes how to configure Postgres-XC in two scenes.

Configuring on your laptop

[Laptop_Configuration] Explains how to configure XC in your laptop computer. This is not for realistic application build and test, but is sufficient to run XC for your own test and experience. What you need is any laptop computer running 64bit Linux operation system. 32bit Linux may work. If you don't have native Linux machine, you can use virtual machine, Virtualbox for example. About 2GB of memory is recommended for real/virtual machine.

Configuring with real servers

[Real_Server_Configuration] describes how to configure XC with three servers. This is good for production. You can run performance benchmarks and real applications with this configuration. You will find it is very starightforward to use more servers.

Before getting started

You should be familiar with Postgres-XC components, to be configured in each environment above.

  1. Coordinator: This is where your application connect to. Coordinator interacts with applications by receiving SQL statements and returning their results. Real data is not stored in the coordinator. It is stored in the datanode.
  2. Datanode: This is where real datanode is stored. Coordinator determines what datanode has the target data of each SQL statement and interacts to the datanode to get the result.
  3. GTM: This stands for Global Transaction Manger. GTM provides internal transaction information to coordinators and datanodes so that they work as single database as a whole.
  4. GTM proxy: This groups up interaction between GTM and other components to improve total performance. Laptop configuration does not need this component (obviously you can configure it if you want).

If you understand what you need to configure, please visit Laptop configuration or Real Server configuration to begin your configuration.


Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.