From: Koichi S. <koi...@gm...> - 2013-05-22 20:54:51
|
Did you issue CREATE NODE before you create databases/roles? If you CREATE NODE after you create databases/users, they are not visible to other node and may fall into errors. When you create each node by initdb, you also create gtm's using initgtm, connect all the datanodes/coordinators to the gtm and then issue CREATE NODE before you create anothing else. You can visit https://github.com/koichi-szk/PGXC-Tools/blob/master/pgxc_ctl/pgxc_ctl to look into pgxc_ctl shell script, which takes care of configuration, failover, start and stop the cluster. init_all function will be helpful for you. This shows what you should do to initialize your cluster. The C-version of pgxc_ctl will be included in coming 1.1 release with new Postgres-XC feature. Regards; |