|
From: Juned K. <jkh...@gm...> - 2014-03-06 05:55:42
|
Hi Koichi, My install directory is */home/postgres/* > > [postgres@localhost ~]$ pgxc_ctl --configuration > /home/postgres/pgxc_ctl/pgxc_ctl.ctl > Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. > Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash. > Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home > /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.ctl > However i am able to connect using psql PGXC psql -p 20004 -h node2 > psql (PGXC 1.1, based on PG 9.2.4) > Type "help" for help. > > postgres=# createdb koichi > but database is not being created. > PGXC psql -p 20004 -h node2 -d koichi > psql: FATAL: database "koichi" does not exist > what could be the problem ? On Thu, Mar 6, 2014 at 11:14 AM, 鈴木 幸市 <ko...@in...> wrote: > You should not use createdb from postgrereSQL. What is your > installation target of PGXC? > > You can also login to the database using psql and issue create database > command. > > Regards; > --- > Koichi Suzuki > > 2014/03/06 14:30、Juned Khan <jkh...@gm...> のメール: > > Hi Koichi, > > Specified port and host but now getting below error: > > PGXC createdb koichi -h node2 -p 20004 >> createdb: database creation failed: ERROR: Failed to get pooled >> connections >> PGXC >> > > And which createdb command i should use which will select coordinator > automatically. > > [root@localhost ~]# find / -name createdb >> /usr/src/postgres-xc/src/bin/scripts/createdb >> /usr/local/pgsql/bin/createdb >> /usr/local/bin/createdb >> > > Please suggest. > > > > > On Thu, Mar 6, 2014 at 10:50 AM, 鈴木 幸市 <ko...@in...> wrote: > >> Is your coordinator running locally? You may have to specify -h option >> to tell where to go. >> >> Or, you can issue Createdb command, which is embedded pgxc_ctl command. >> Createdb will chose one of the available coordinators and go there. >> >> Regards; >> --- >> Koichi Suzuki >> >> 2014/03/06 14:16、Juned Khan <jkh...@gm...> のメール: >> >> Hi Lin , >> >> Still its not working, same issue >> >> PGXC createdb astpp -p 20004 >>> createdb: could not connect to database template1: could not connect to >>> server: No such file or directory >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.20004"? >>> PGXC >>> >> >> >> >> >> On Wed, Mar 5, 2014 at 9:01 PM, Lin Wang <lin...@gm...> wrote: >> >>> I think you need point out one port of the coordinators when you >>> create a database, for example as below: >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 >>> createdb: could not connect to database template1: could not connect to >>> server: no that file or folder >>> Is the server running locally and accepting >>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>> >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/createdb db1 -p >>> 5300 >>> [wln@localhost pgxc]$ /home/wln/pgxc/install_1_1/bin/psql -d postgres >>> -p 5300 -c "\l" >>> List of databases >>> Name | Owner | Encoding | Collate | Ctype | Access >>> privileges >>> >>> -----------+-------+----------+-------------+-------------+------------------- >>> db1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> postgres | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | >>> template0 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> template1 | wln | UTF8 | zh_CN.UTF-8 | zh_CN.UTF-8 | =c/wln >>> + >>> | | | | | wln=CTc/wln >>> (4 rows) >>> >>> >>> Good Luck >>> --------- >>> waln >>> >>> >>> 2014-03-05 22:11 GMT+08:00 Juned Khan <jkh...@gm...>: >>> >>>> Hi All, >>>> >>>> Since last few days i am trying to setup postgre-xc with 3 local >>>> systems. >>>> I have done with basic setup, but having issue with database creation. >>>> >>>> Below is the output of monitor all >>>> >>>> PGXC monitor all >>>>> Running: gtm master >>>>> Running: coordinator master coord1 >>>>> Running: coordinator master coord2 >>>>> Running: datanode master datanode1 >>>>> Running: datanode master datanode2 >>>>> >>>> >>>> But when i am trying to create database its giving me below error. >>>> >>>> PGXC createdb astpp; >>>>> createdb: could not connect to database template1: could not connect >>>>> to server: No such file or directory >>>>> Is the server running locally and accepting >>>>> connections on Unix domain socket "/tmp/.s.PGSQL.5432"? >>>>> PGXC >>>>> >>>> >>>> I am just one step away to done with my postgre-xc setup. >>>> Please suggest me, how to get it fixed . >>>> >>>> >>>> >>>> -- >>>> Thanks, >>>> Juned Khan >>>> iNextrix Technologies Pvt Ltd. >>>> www.inextrix.com >>>> >>>> >>>> ------------------------------------------------------------------------------ >>>> Subversion Kills Productivity. Get off Subversion & Make the Move to >>>> Perforce. >>>> With Perforce, you get hassle-free workflows. Merge that actually works. >>>> Faster operations. Version large binaries. Built-in WAN optimization >>>> and the >>>> freedom to use Git, Perforce or both. Make the move to Perforce. >>>> >>>> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk >>>> _______________________________________________ >>>> Postgres-xc-general mailing list >>>> Pos...@li... >>>> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >>>> >>>> >>> >> >> >> -- >> Thanks, >> Juned Khan >> iNextrix Technologies Pvt Ltd. >> www.inextrix.com >> ------------------------------------------------------------------------------ >> Subversion Kills Productivity. Get off Subversion & Make the Move to >> Perforce. >> With Perforce, you get hassle-free workflows. Merge that actually works. >> Faster operations. Version large binaries. Built-in WAN optimization and >> the >> freedom to use Git, Perforce or both. Make the move to Perforce. >> >> http://pubads.g.doubleclick.net/gampad/clk?id=122218951&iu=/4140/ostg.clktrk_______________________________________________ >> Postgres-xc-general mailing list >> Pos...@li... >> https://lists.sourceforge.net/lists/listinfo/postgres-xc-general >> >> >> > > > -- > Thanks, > Juned Khan > iNextrix Technologies Pvt Ltd. > www.inextrix.com > > > -- Thanks, Juned Khan iNextrix Technologies Pvt Ltd. www.inextrix.com |