From: Donald K. <don...@gm...> - 2013-05-23 14:59:09
|
Andrei, Thanks! That was it. I set the hba for the datanodes as the same as coordinators. There was no documentation that I saw about the datanodes hba has to be passwordless (or in trust mode from all coordinators for all users). Again, thanks for the help! On Thu, May 23, 2013 at 3:36 AM, Andrei Martsinchyk < and...@gm...> wrote: > 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 > > > > ------------------------------------------------------------------------------ > 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 > > |