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

[Juned K. <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