[Postgres-xl-general] Can't create slave

Gonzalo Tamos gonzalo.tamos at acciona-it.com.ar
Mon Dec 5 08:49:41 PST 2016


Hi all,

I'm testing postgres-xl to understand how it works.

I'm following the steps of the documentation to create a data base cluster
but when I tyried to create one slave just like the example, I have this
problem:

PGXC monitor all

Running: gtm master
Running: coordinator master coord1
Running: coordinator master coord2
Running: datanode master dn1
Running: datanode master dn2

PGXC add datanode slave dn1 localhost 40101 40111 $dataDirRoot/dn_slave.1
none $dataDirRoot/datanode_archlog.1

Actual Command: ssh postgres at localhost "( mkdir -p
$dataDirRoot/dn_slave.1;chmod 0700 $dataDirRoot/dn_slave.1 ) >
/tmp/ubuntu-server-2_STDOUT_18453_4 2>&1" < /dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/ubuntu-server-2_STDOUT_18453_4
/tmp/STDOUT_18453_5 > /dev/null 2>&1
Actual Command: ssh postgres at localhost "( rm -rf
$dataDirRoot/datanode_archlog.1; mkdir -p $dataDirRoot/datanode_archlog.1;chmod
0700 $dataDirRoot/datanode_archlog.1 ) > /tmp/ubuntu-server-2_STDOUT_18453_6
2>&1" < /dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/ubuntu-server-2_STDOUT_18453_6
/tmp/STDOUT_18453_7 > /dev/null 2>&1
Actual Command: ssh postgres at localhost "( rm -rf none; mkdir -p none;chmod
0700 none ) > /tmp/ubuntu-server-2_STDOUT_18453_8 2>&1" < /dev/null >
/dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/ubuntu-server-2_STDOUT_18453_8
/tmp/STDOUT_18453_9 > /dev/null 2>&1
Actual Command: ssh postgres at localhost "( pg_ctl stop -w -Z datanode -D
/home/postgres/DATA/pgxl/nodes/dn_master.1 -m fast ) >
/tmp/ubuntu-server-2_STDOUT_18453_10 2>&1" < /dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/
ubuntu-server-2_STDOUT_18453_10 /tmp/STDOUT_18453_11 > /dev/null 2>&1
Actual Command: ssh postgres at localhost "( pg_ctl start -w -Z datanode -D
/home/postgres/DATA/pgxl/nodes/dn_master.1 ) >
/tmp/ubuntu-server-2_STDOUT_18453_12
2>&1" < /dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/
ubuntu-server-2_STDOUT_18453_12 /tmp/STDOUT_18453_13 > /dev/null 2>&1
LOG:  redirecting log output to logging collector process
HINT:  Future log output will appear in directory "pg_log".
pg_ctl: could not start server
Examine the log output.
Actual Command: ssh postgres at localhost "( pg_basebackup -p 40001 -h
localhost -D $dataDirRoot/dn_slave.1 -x   ) >
/tmp/ubuntu-server-2_STDOUT_18453_14
2>&1" < /dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/
ubuntu-server-2_STDOUT_18453_14 /tmp/STDOUT_18453_15 > /dev/null 2>&1
pg_basebackup: could not connect to server: could not connect to server:
Connection refused
        Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 40001?
could not connect to server: Connection refused
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 40001?
Actual Command: ssh postgres at localhost "( pg_ctl start -w -Z datanode -D
$dataDirRoot/dn_slave.1 ) > /tmp/ubuntu-server-2_STDOUT_18453_16 2>&1" <
/dev/null > /dev/null 2>&1
Bring remote stdout: scp postgres at localhost:/tmp/
ubuntu-server-2_STDOUT_18453_16 /tmp/STDOUT_18453_17 > /dev/null 2>&1
postgres: Postgres-XL: must start as either a Coordinator (--coordinator)
or Data Node (--datanode)
pg_ctl: could not determine the data directory using command
""/usr/local/pgsql/bin/postgres" -C data_directory -D
"/home/postgres/DATA/pgxl/nodes/dn_slave.1" "

PGXC monitor all

Running: gtm master
Running: coordinator master coord1
Running: coordinator master coord2
Not running: datanode master dn1
Not running: datanode slave dn1
Running: datanode master dn2

PGXC

when I create de dn1 slave, dn1 master stops working and the slave cannot
start.

I checked the log file of the dn1 master and it contains the follow:

postgres at ubuntu-server-2:~/DATA/pgxl/nodes/dn_master.1/pg_log$ cat
postgresql-2016-12-05_120439.log

LOG:  invalid authentication method "(::1/32"
CONTEXT:  line 101 of configuration file "/home/postgres/DATA/pgxl/
nodes/dn_master.1/pg_hba.conf"
FATAL:  could not load pg_hba.conf

And line 101 of the pg_hba.conf is:

host replication postgres localhost (::1/32 trust

can you help mi with this?

What am I missing?

Regards!

Gonzalo.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20161205/806966a0/attachment.htm>


More information about the postgres-xl-general mailing list