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

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

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