Menu
▾
▴
Re: [Postgres-xc-general] Problem with creating database
|
From: Juned K. <jkh...@gm...> - 2014-03-06 07:13:59
|
Hi Koichi, create database command is not working infact Createdb is worked but in that case error is somewhat changed (Failed to get pooled connections ) PGXC Createdb koichi; > Selected coord1. > createdb: database creation failed: ERROR: Failed to get pooled > connections > PGXC > still i need to do reinstall or this error is not related to configuration ? If yes then i will reinstall it quickly on all servers. On Thu, Mar 6, 2014 at 12:29 PM, Koichi Suzuki <koi...@gm...>wrote: > Please check the following steps: > > 1) cd to your postgres-xc source directory (at the top) > 2) ./configure --prefix=/usr/local/pgsql/include/server/pgxc > --enable-debug # this is a good practice to enable this. > 3) make > 4) make install > 5) make sure your pgxc binary went to the directory specified in --prefix > option > 6) pgxc_ctl --configure (your configuration file) > 7) deploy all # invoke within pgxc_ctl You should give write privilege > 8) Meke sure that all the binaries are installed in all the target > servers. which commandname will show you what binary really runs as > commandname command > 9) init all # invoke within pgxc_ctl > 10) Createdb dbname #invoke within pgxc_ctl, be sure to capitalize the > first letter. > > Please make sure that you've given appropriate privilege to xc > installation directory and each database installation directory, > specified by gtmMasterDir, cordMasterDirs and DatanodeMasterDirs in > each target server respectively. > > Regards; > --- > Koichi Suzuki > > > 2014-03-06 14:44 GMT+09:00 鈴木 幸市 <ko...@in...>: > > 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 > > > > > > > > > ------------------------------------------------------------------------------ > > 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 |
