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

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

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
>