From: Donald K. <don...@gm...> - 2013-05-23 15:21:32
|
actually selecting for the tables works. So I can run queries. But i can't do any dmls or ddls in the database (ie create tables, insert/update/delete). On Thu, May 23, 2013 at 10:59 AM, Donald Keyass <don...@gm...>wrote: > 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 >> >> > |