|
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===================
|