[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