192.168.1.36數(shù)據(jù)節(jié)點(diǎn)一: db_1   15431數(shù)據(jù)節(jié)點(diǎn)二: db_2   15432

export PGHOME=/opt/pgsql_xcexport LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/libexport DATE=`date +"%Y%m%d%H%M"`export PATH=$PGHOME/bin:$PATH:.export MANPATH=$PGHOME/share/man:$MANPATHalias rm='rm -i'alias ll='ls -lh'  

# - Where to Log -log_destination = 'csvlog'logging_collector = on  log_directory = 'pg_log'  log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'log_truncate_on_rotation = on log_rotation_age = 1d  log_rotation_size = 10MB  gtm_host = 'localhost'

# GTM CONNECTIONgtm_host = '192.168.1.35'gtm_port = 6666 pgxc_node_name = 'db_1'

# DATA NODES AND CONNECTION POOLINGpooler_port = 6667 max_pool_size = 100

# - Where to Log -log_destination = 'csvlog'logging_collector = on  log_directory = 'pg_log'  log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'log_truncate_on_rotation = on log_rotation_age = 1d  log_rotation_size = 10MB  gtm_host = 'localhost'

# GTM CONNECTIONgtm_host = '192.168.1.35'gtm_port = 6666 pgxc_node_name = 'db_2'

# DATA NODES AND CONNECTION POOLINGpooler_port = 6667 max_pool_size = 100

export PGHOME=/opt/pgsql_xc

export LD_LIBRARY_PATH=$PGHOME/lib:/lib64:/usr/lib64:/usr/local/lib64:/lib:/usr/lib:/usr/local/libexport DATE=`date +"%Y%m%d%H%M"`export PATH=$PGHOME/bin:$PATH:.export MANPATH=$PGHOME/share/man:$MANPATHalias rm='rm -i'alias ll='ls -lh'

 [pgxc@redhat6 bin]$ initgtm -Z gtm -D /database/1922/pgdata1/pgdata_xc/gtmThe files belonging to this GTM system will be owned by user "pgxc".This user must also own the server process.

fixing permissions on existing directory /database/1922/pgdata1/pgdata_xc/gtm ... okcreating configuration files ... ok

Success. You can now start the GTM server using:

    gtm -D /database/1922/pgdata1/pgdata_xc/gtmor    gtm_ctl -Z gtm -D /database/1922/pgdata1/pgdata_xc/gtm -l logfile start

# - Where to Log -log_destination = 'csvlog'logging_collector = on  log_directory = 'pg_log'  log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'log_truncate_on_rotation = on log_rotation_age = 1d  log_rotation_size = 10MB  gtm_host = 'localhost'

# GTM CONNECTIONgtm_host = 'localhost'gtm_port = 6666 pgxc_node_name = 'coord1'

# DATA NODES AND CONNECTION POOLINGpooler_port = 6667max_pool_size = 100

# - Connection Settings -listen_addresses = '*'port = 1925

# - Where to Log -log_destination = 'csvlog'logging_collector = on  log_directory = 'pg_log'  log_filename = 'postgresql-%Y-%m-%d_%H%M%S.log'log_truncate_on_rotation = on log_rotation_age = 1d  log_rotation_size = 10MB  gtm_host = 'localhost'

# GTM CONNECTIONgtm_host = 'localhost'gtm_port = 6666 pgxc_node_name = 'coord2'

# DATA NODES AND CONNECTION POOLINGpooler_port = 6668max_pool_size = 100

[pgxc@redhat6 bin]$ ps -ef | grep gtmpgxc      6185  6135  0 20:50 pts/4    00:00:00 gtm -D /database/1922/pgdata1/pgdata_xc/gtm

[pgxc@redhat6 gtm]$ psql -p 1921 -U postgrespsql (PGXC 1.0beta2, based on PG 9.1.3)Type "help" for help.

postgres=# select * from pgxc_node; node_name | node_type | node_port | node_host | nodeis_primary | nodeis_preferred |  node_id  -----------+-----------+-----------+-----------+----------------+------------------+------------ coord1    | C         |      5432 | localhost | f              | f                | 1885696643(1 row)

postgres=# CREATE NODE db_1 WITH (TYPE='datanode',HOST = '192.168.1.36', PORT=15431,PRIMARY, PREFERRED);CREATE NODEpostgres=# CREATE NODE db_2 WITH (TYPE='datanode',HOST = '192.168.1.36', PORT=15432);CREATE NODEpostgres=# CREATE NODE coord2 WITH (TYPE='coordinator',HOST = '192.168.1.35', PORT=1925);CREATE NODEpostgres=# select * from pgxc_node; node_name | node_type | node_port |  node_host   | nodeis_primary | nodeis_preferred |   node_id  -----------+-----------+-----------+--------------+----------------+------------------+------------- coord1    | C         |      5432 | localhost    | f              | f                |  1885696643 db_1      | D         |     15431 | 192.168.1.36 | f              | f                |  1356996994 db_2      | D         |     15432 | 192.168.1.36 | f              | f                |  -822936791 coord2    | C         |      1925 | localhost    | f              | f                | -1197102633

postgres=# select pgxc_pool_reload(); pgxc_pool_reload ------------------ t(1 row)

postgres=# /l                             List of databases   Name    |  Owner   | Encoding | Collate | Ctype |   access privileges    -----------+----------+----------+---------+-------+------------------------ francs    | postgres | UTF8     | C       | C     | =Tc/postgres          +           |          |          |         |       | postgres=CTc/postgres +           |          |          |         |       | francs=C*T*c*/postgres postgres  | postgres | UTF8     | C       | C     |  template0 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres template1 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres(4 rows)

postgres=# create database test_xc;CREATE DATABASE

postgres=# /l                             List of databases   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges    -----------+----------+----------+---------+-------+------------------------ postgres  | postgres | UTF8     | C       | C     |  template0 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres template1 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres test_xc   | postgres | UTF8     | C       | C     |(5 rows)

postgres=# /c test_xcYou are now connected to database "test_xc" as user "postgres".test_xc=# create table test_1 (id integer,name varchar(32));CREATE TABLEtest_xc=# insert into test_1 select generate_series(1,100),'test_xc';INSERT 0 100

postgres=# /l                             List of databases   Name    |  Owner   | Encoding | Collate | Ctype |   Access privileges    -----------+----------+----------+---------+-------+------------------------ postgres  | postgres | UTF8     | C       | C     |  template0 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres template1 | postgres | UTF8     | C       | C     | =c/postgres           +           |          |          |         |       | postgres=CTc/postgres test_xc   | postgres | UTF8     | C       | C     | (5 rows)

postgres=# /c test_xcYou are now connected to database "test_xc" as user "postgres".test_xc=# /d         List of relations Schema |  Name  | Type  |  Owner   --------+--------+-------+---------- public | test_1 | table | postgres(1 row)

test_xc=# select count(*) from test_1; count -------   100(1 row)

test_xc=# /dWARNING:  Do not have a GTM snapshot availableWARNING:  Do not have a GTM snapshot available         List of relations Schema |  Name  | Type  |  Owner   --------+--------+-------+---------- public | test_1 | table | postgres(1 row)

test_xc=# select count(*) from test_1;WARNING:  Do not have a GTM snapshot availableWARNING:  Do not have a GTM snapshot available count -------    42(1 row)

test_xc=# select count(*) from test_1;WARNING:  Do not have a GTM snapshot availableWARNING:  Do not have a GTM snapshot available count -------    58(1 row)