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

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

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
>