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

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

Please specify "create database", not "createdb".   createdb is a
shortcut command so you will get an error message.

Regards;
---
Koichi Suzuki

2014-03-06 14:55 GMT+09:00 Juned Khan <jkh...@gm...>:
> Hi Koichi,
>
> My install directory is /home/postgres/
>
>> [postgres@localhost ~]$ pgxc_ctl --configuration
>> /home/postgres/pgxc_ctl/pgxc_ctl.ctl
>> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
>> Installing pgxc_ctl_bash script as /home/postgres/pgxc_ctl/pgxc_ctl_bash.
>> Reading configuration using /home/postgres/pgxc_ctl/pgxc_ctl_bash --home
>> /home/postgres/pgxc_ctl --configuration /home/postgres/pgxc_ctl/pgxc_ctl.ctl
>
>
> However i am able to connect using psql
>
>> PGXC psql -p 20004 -h node2
>> psql (PGXC 1.1, based on PG 9.2.4)
>> Type "help" for help.
>>
>> postgres=# createdb koichi
>
>
> but database is not being created.
>>
>> PGXC psql -p 20004 -h node2 -d koichi
>> psql: FATAL:  database "koichi" does not exist
>
>
> what could be the problem ?
>
>
>
> On Thu, Mar 6, 2014 at 11:14 AM, 鈴木 幸市 <ko...@in...> wrote:
>>
>> 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
>>
>>
>
>
>
> --
> 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
>