From: Donald K. <don...@gm...> - 2013-05-22 21:43:20
|
The testdb and user were the very last thing I created after I created the node. On Wed, May 22, 2013 at 4:54 PM, Koichi Suzuki <koi...@gm...>wrote: > 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; > |