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

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