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

[鈴木 幸市 <ko...@in...>]

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...<mailto: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...<mailto: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...<mailto: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<http://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...<mailto:Pos...@li...>
https://lists.sourceforge.net/lists/listinfo/postgres-xc-general





--
Thanks,
Juned Khan
iNextrix Technologies Pvt Ltd.
www.inextrix.com<http://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