From: cheng c. <ke...@ho...> - 2010-10-06 05:25:53
|
Dear All I have installed postgres-XC 0.9.2 version with single node. I met some problem with trying to use pgadmin to connect database from coordinate but it is sucess to connect from datanode. pgadmin is just hanging there. startup command is blow: /usr/local/pgsql/bin/gtm -p 6666 -D /data/gtm/ & /usr/local/pgsql/bin/postgres -X -i -p 15432 -D /data/datanode/ & /usr/local/pgsql/bin/postgres -C -i -p 5432 -D /data/coord/ & the configuration file is below: coordinate & datanode ==========================pgxc.conf==================== coordinator_hosts = '172.22.5.39' # Host names or addresses of data nodes # (change requires restart) coordinator_ports = '5432' # Port numbers of coordinators # (change requires restart) coordinator_folders = '/data/coord' # List of Data folders of coordinators # (change require restart) ==========================end pgxc.conf==================== ==========================postgres.conf=================== pooler_port = 6667 # Pool Manager TCP port # (change requires restart) num_data_nodes = 1 # Number of Data Nodes # (change requires restart) min_pool_size = 1 # Initial pool size # (change requires restart) max_pool_size = 50 # Maximum pool size # (change requires restart) data_node_hosts = '172.22.5.39' # Host names or addresses of data nodes # (change requires restart) data_node_ports = '15432' # Port numbers of data nodes # (change requires restart) data_node_users = 'postgres' # User names of data nodes # (change requires restart) data_node_passwords = 'postgres' # Passwords of data nodes # (change requires restart) primary_data_node = 1 # Which data node to use first for # replicated writes #------------------------------------------------------------------------------ # GTM CONNECTION #------------------------------------------------------------------------------ gtm_host = '172.22.5.39' # Host name or address of GTM # (change requires restart) gtm_port = 6666 # Port of GTM # (change requires restart) gtm_coordinator_id = 1 # Coordinator identifier # (change requires restart) ==========================end postgres.conf=================== |