# - Connection Settings -

listen_addresses = '*'

port = 5432

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#-------------------------------------------

pooler_port = 6667

min_pool_size = 1

max_pool_size = 100

# GTM CONNECTION

#----------------------

gtm_host = '172.16.0.101'

gtm_port = 6666

pgxc_node_name = 'co1'

172.16.0.103这台机器上 coordinator配置文件/home/pgxc/coordinator/pg_hba.conf的内容如下:

# IPv4 local connections:

host all all 127.0.0.1/32 trust

host all all 172.16.0.0/24 trust

host all all 0.0.0.0/0 md5

?

172.16.0.103这台机器上数据节点配置文件/home/pgxc/pgdata/postgresql.conf的内容如下:

# - Connection Settings -

listen_addresses = '*'

port = 5433

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#----------------------------------------

pooler_port = 6668

#min_pool_size = 1

max_pool_size = 100

?

# GTM CONNECTION

#---------------------------

gtm_host = '172.16.0.101'

gtm_port = 6666

pgxc_node_name = 'dn1'

?

172.16.0.103这台机器上数据节点配置文件/home/pgxc/pgdata/pg_hba.conf的内容如下:

# IPv4 local connections:

host all all 127.0.0.1/32 trust

host all all 172.16.0.0/24 trust

host all all 0.0.0.0/0 md5

?

2.在172.16.0.104这台机器上运行如下命令：

initdb -D /home/pgxc/coordinator --nodename co2 -E UTF8 --local=C -U pgxc -W

initdb -D /home/pgxc/pgdata --nodename dn2 -E UTF8 --local=C -U pgxc -W

?

172.16.0.104这台机器上 coordinator配置文件/home/pgxc/coordinator/postgresql.conf的内容如下:

# - Connection Settings -

listen_addresses = '*'

port = 5432

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#-------------------------------------------

pooler_port = 6667

min_pool_size = 1

max_pool_size = 100

# GTM CONNECTION

#----------------------

gtm_host = '172.16.0.101'

gtm_port = 6666

pgxc_node_name = 'co2'

172.16.0.104这台机器上 coordinator配置文件/home/pgxc/coordinator/pg_hba.conf的内容如下:

# IPv4 local connections:

host all all 127.0.0.1/32 trust

host all all 172.16.0.0/24 trust

host all all 0.0.0.0/0 md5

?

172.16.0.104这台机器上数据节点配置文件/home/pgxc/pgdata/postgresql.conf的内容如下:

# - Connection Settings -

listen_addresses = '*'

port = 5433

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#----------------------------------------

pooler_port = 6668

#min_pool_size = 1

max_pool_size = 100

?

# GTM CONNECTION

#---------------------------

gtm_host = '172.16.0.101'

gtm_port = 6666

pgxc_node_name = 'dn2'

?

172.16.0.104这台机器上数据节点配置文件/home/pgxc/pgdata/pg_hba.conf的内容如下:

# IPv4 local connections:

host all all 127.0.0.1/32 trust

host all all 172.16.0.0/24 trust

host all all 0.0.0.0/0 md5

?

3. 在172.16.0.105这台机器上运行如下命令：

initdb -D /home/pgxc/coordinator --nodename co3 -E UTF8 --local=C -U pgxc -W

initdb -D /home/pgxc/pgdata --nodename dn3 -E UTF8 --local=C -U pgxc -W

?

172.16.0.105这台机器上 coordinator配置文件/home/pgxc/coordinator/postgresql.conf的内容如下:

# - Connection Settings -

listen_addresses = '*'

port = 5432

max_connections = 100

# DATA NODES AND CONNECTION POOLING

#-------------------------------------------

pooler_port = 6667

min_pool_size = 1

max_pool_size = 100

# GTM CONNECTION

#----------------------

gtm_host = '172.16.0.101'

gtm_port = 6666

pgxc_node_name = 'co3'

172.16.0.105这台机器上 coordinator配置文件/home/pgxc/coordinator/pg_hba.conf的内容如下:

# IPv4 local connections:

host all all 127.0.0.1/32 trust

host all all 172.16.0.0/24 trust

host all all 0.0.0.0/0 md5

?