createuser temp, psql postgres and createdb newdb not working in postgres-xl?

Question

I am using postgres-xl in ubuntu 12.04.

when i try to use createuser temp, psql postgres, createdb newdb error is

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

my setting is

  listen_addresses = 'localhost'
    port = 9999             
    max_connections = 100   
    unix_socket_directory = '/usr/local/pgsql'


# TYPE  DATABASE        USER            ADDRESS                 METHOD

# "local" is for Unix domain socket connections only
local   all             all                                     trust
# IPv4 local connections:         127.0.0.1/32  
host    all             all             0.0.0.0/0            trust
# IPv6 local connections:
host    all             all             ::1/128                 trust
# Allow replication connections from localhost, by a user with the
# replication privilege.
#local   replication     apple                                trust
#host    replication     apple        127.0.0.1/32            trust
#host    replication     apple        ::1/128                 trust

Could you write down "psql" full command ? – Chen Yu Jul 24 '15 at 10:05 — Chen Yu, Jul 24 '15 at 10:05
I run this command ./createdb newdb. – Muhammad Raza Jul 27 '15 at 01:33 — Muhammad Raza, Jul 27 '15 at 01:33

score 0 · Answer 1 · answered Sep 27 '15 at 07:45

I suppose you're trying to connect to coordinator running on port 5432:

connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

But your in your config file port is 9999

listen_addresses = 'localhost'
port = 9999
max_connections = 100

You should run createdb command like this. Database user must have rights to create db.

./createdb --port=9999 --host=localhost --username=<USERNAME>

score 0 · Answer 2 · answered Oct 06 '16 at 05:35

Well there can be many possible reasons for the error message you received. As suggested by Igor check the configuration file.

Else, I suggest you to use pgxc_ctl command line tool to automatically generate the basic configuration file which you can later change/modify.

createuser temp, psql postgres and createdb newdb not working in postgres-xl?

2 Answers2