Re: [Postgres-xc-general] Problem with creating database

SourceForge Headquarters 1320 Columbia Street Suite 310 San Diego, CA 92101 +1 (858) 422-6466

Hi Mastaka,

You hint worked for me. default setting was fine for my environment
but i set static IP there and its worked like

coordPgHbaEntries=(192.168.1.72/32 192.168.1.73/32 )
datanodePgHbaEntries=(192.168.1.72/32 192.168.1.73/32)

thank you very much.

On Thu, Mar 6, 2014 at 1:01 PM, Masataka Saito <pg...@gm...> wrote:

> On 6 March 2014 16:13, Juned Khan <jkh...@gm...> wrote:
> > 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
> >
>
> Did you customize coordPgHbaEntries and datanodePgHbaEntries
> parameters in pgxc_ctl.conf (or your configuration file) to suite your
> environment? The coordinator need to be privileged to access to other
> nodes (coordinators and datanodes) without authorization.
>
> Unfortunately default pgxc_ctl.conf is just a sample and it is not
> work well without customize. So you need to glance over the
> configuration to ensure that the parameters are suitable for you.
>
> Regards.
>
> >
> > 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
> >
> >
> ------------------------------------------------------------------------------
> > 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