From: Andrei M. <and...@gm...> - 2013-05-23 07:36:58
|
Hi Donald, Please checke your pg_hba.conf on the datanodes, they should allow passwordless access from coordinators. When coordinator builds up connection string it does not include the password. 2013/5/23 Koichi Suzuki <koi...@gm...> > The following is a typical additional postgresql.conf file lines for > coordinators. They're generated by pgxc_ctl utility and works well. > Could you compare this with your ones? Especially, I'm interested how you > configured pooler_port. > > Regards; > > ----8<----8<---- > #=========================================== > # Added at initialization. 20130523_11:33:33 > port = 20004 > pooler_port = 20010 > gtm_host = 'node13' > gtm_port = 20001 > # End of Additon > ---->8------->8------ > > > ---------- > Koichi Suzuki > > > 2013/5/22 Nikhil Sontakke <ni...@st...> > >> Hi Donald, >> >> This looks like a user permissions related internal bug in PGXC. >> >> Regards, >> Nikhils >> >> >> >> On Thu, May 23, 2013 at 3:13 AM, Donald Keyass < >> don...@gm...> wrote: >> >>> 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_ctlto 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; >>>> >>> >>> >>> >>> ------------------------------------------------------------------------------ >>> Try New Relic Now & We'll Send You this Cool Shirt >>> New Relic is the only SaaS-based application performance monitoring >>> service >>> that delivers powerful full stack analytics. Optimize and monitor your >>> browser, app, & servers with just a few lines of code. Try New Relic >>> and get this awesome Nerd Life shirt! >>> http://p.sf.net/sfu/newrelic_d2d_may >>> _______________________________________________ >>> Postgres-xc-general mailing list >>> Pos...@li... >>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>> >>> >> >> >> -- >> StormDB - http://www.stormdb.com >> The Database Cloud >> > > > > ------------------------------------------------------------------------------ > Try New Relic Now & We'll Send You this Cool Shirt > New Relic is the only SaaS-based application performance monitoring service > that delivers powerful full stack analytics. Optimize and monitor your > browser, app, & servers with just a few lines of code. Try New Relic > and get this awesome Nerd Life shirt! http://p.sf.net/sfu/newrelic_d2d_may > _______________________________________________ > Postgres-xc-general mailing list > Pos...@li... > https://lists.sourceforge.net/lists/listinfo/postgres-xc-general > > -- Andrei Martsinchyk StormDB - http://www.stormdb.com The Database Cloud |