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

[Lin W. <lin...@gm...>]

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
>
>