tm_proxy2/ -Z gtm_proxy
The files belonging to this GTM system will be owned by user "pgxl".
This user must also own the server process.
?
creating directory /opt/pgxl/data/gtm_proxy2 ... ok
creating configuration files ... ok
?
Success. You can now start the GTM proxy server using:
?
? ? ./gtm_proxy -D /opt/pgxl/data/gtm_proxy2
or
? ? ./gtm_ctl -Z gtm_proxy -D /opt/pgxl/data/gtm_proxy2 -l logfile start
配置信息：
gtm节点配置（修改项）：
[pgxl@localhost data_gtm]$ vi gtm.conf
nodename = 'gtm'? ? ? ? ? ? ? ? ?
listen_addresses = '*'
keepalives_idle = 60? ? ? ?
keepalives_interval = 10? ?
keepalives_count = 10
node1节点配置（修改项）：
[pgxl@localhost gtm_proxy1]$ vi gtm_proxy.conf
nodename = 'gtm_proxy1'? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
listen_addresses = '*'? ? ? ? ? ? ? ?
port = 6661? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
gtm_host = '192.168.100.199'? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
gtm_port = 6666
keepalives_idle = 60
keepalives_interval = 10
keepalives_count = 10
[pgxl@localhost coordinator1]$ vi postgresql.conf
listen_addresses = '*'
#gtm_host = 'localhost'? ? ? ? ? ? ? ?
gtm_port = 6661? ? ? ? ? ? ?
pgxc_node_name = 'coordinator1' pooler_port = 6667
[pgxl@localhost coordinator1]$ vi pg_hba.conf
host? ? all? ? ? ? ? ? all? ? ? ? ? ? 192.168.100.0/24? ? ? ? ? ? trust
[pgxl@localhost datanode1]$ vi postgresql.conf
listen_addresses = '*'
port = 15432
#gtm_host = 'localhost'
gtm_port = 6661? ? ? ? ? ?
pgxc_node_name = 'datanode1'
pooler_port = 6668
[pgxl@localhost datanode1]$ vi pg_hba.conf
host? ? all? ? ? ? ? ? all? ? ? ? ? ? 192.168.100.0/24? ? ? ? ? ? trust
node2节点配置（修改项）：
[pgxl@localhost gtm_proxy2]$ vi gtm_proxy.conf
nodename = 'gtm_proxy2'? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
listen_addresses = '*'? ? ? ? ? ? ? ?
port = 6662? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
gtm_host = '192.168.100.199'? ? ? ? ? ? ? ? ? ? ? ? ? ? ? ?
gtm_port = 6666
keepalives_idle = 60
keepalives_interval = 10
keepalives_count = 10
[pgxl@localhost coordinator2]$ vi postgresql.conf
listen_addresses = '*'
#gtm_host = 'localhost'? ? ? ? ? ? ? ?
gtm_port = 6662? ? ? ? ? ? ?
pgxc_node_name = 'coordinator2'
pooler_port = 6667
[pgxl@localhost coordinator2]$ vi pg_hba.conf
host? ? all? ? ? ? ? ? all? ? ? ? ? ? 192.168.100.0/24? ? ? ? ? ? trust
[pgxl@localhost datanode2]$ vi postgresql.conf
listen_addresses = '*'
port = 15432
#gtm_host = 'localhost'
gtm_port = 6662? ? ? ? ? ?
pgxc_node_name = 'datanode2'
pooler_port = 6668
[pgxl@localhost datanode2]$ vi pg_hba.conf
host? ? all? ? ? ? ? ? all? ? ? ? ? ? 192.168.100.0/24? ? ? ? ? ? trust
服务启动：
gtm节点：
[pgxl@localhost bin]$ export PGHOME=/opt/pgxl/
[pgxl@localhost bin]$ export PATH=$PGHOME/bin:$PATH
[pgxl@localhost bin]$ ./gtm_ctl start -Z gtm -D /opt/pgxl/data_gtm/
server starting
[pgxl@localhost bin]$ tail ../data_gtm/gtm.log
1:139738148718336:2015-06-09 14:23:08.247 CST -LOG:? Starting GTM server at (*:6666) -- control file /opt/pgxl/data_gtm/gtm.control
LOCATION:? main, main.c:601
1:139738148718336:2015-06-09 14:23:08.247 CST -LOG:? Restoring last GXID to 10000
? ?
LOCATION:? GTM_RestoreTxnInfo, gtm_txn.c:2673
1:139738148718336:2015-06-09 14:23:08.247 CST -LOG:? Started to run as GTM-Active.
LOCATION:? main, main.c:682
node1节点：
[pgxl@localhost bin]$ export PGHOME=/opt/pgxl/
[pgxl@localhost bin]$ export PATH=$PGHOME/bin:$PATH
[pgxl@localhost bin]$ ./gtm_ctl start -Z gtm_proxy -D ../data/gtm_proxy1/
server starting
[pgxl@localhost bin]$ tail ../data/gtm_proxy1/gtm_proxy.log
1:47078985160944:2015-06-08 23:27:22.567 PDT -LOG:? Starting GTM proxy at (*:6661)
LOCATION:? main, pro