[Postgres-xl-bugs] pgxl add slave node failed

Zhang Eamon zhang.eamon at hotmail.com
Mon Mar 7 17:09:03 PST 2016


Hi

  I am using pgxl for serveral days, one issuse ,

when i create  a Postgres-XL cluster follow  document  http://files.postgres-xl.org/documentation/tutorial-createcluster.html

It is ok .

I want to a slave node in cluster with command

add coordinator slave name host port pooler dir archDir
,
add datanode slave name host port pooler dir xlogdir archDir  http://files.postgres-xl.org/documentation/pgxc-ctl.html

it seems add node success. but could not start .
------------------------------------------------------------------------------------------------
PGXC monitor all
Running: gtm master
Running: coordinator master coord1
Not running: coordinator slave coord1
PGXC start coordinator slave coord1
Starting coordinator slave coord1.
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/coord_slave.1" -i"
Done
PGXC
------------------------------------------------------------------------------------------------


files in dir home/postgres/DATA/pgxl/nodes/coord_slave.1
------------------------------------------------------------------------------------------------

[postgres at localhost ~]$ ll /home/postgres/DATA/pgxl/nodes/coord_slave.1/
total 8
-rw-rw-r--. 1 postgres postgres 243 Mar  8 00:51 postgresql.conf
-rw-rw-r--. 1 postgres postgres 305 Mar  8 00:51 recovery.conf
[postgres at localhost ~]$
------------------------------------------------------------------------------------------------

then
------------------------------------------------------------------------------------------------

[postgres at localhost ~]$ postgres -C data_directory -D "/home/postgres/DATA/pgxl/nodes/coord_slave.1" -i
postgres: Postgres-XL: must start as either a Coordinator (--coordinator) or Data Node (--datanode)
------------------------------------------------------------------------------------------------

then

------------------------------------------------------------------------------------------------

[postgres at localhost ~]$ postgres -C data_directory -D "/home/postgres/DATA/pgxl/nodes/coord_slave.1" -i --coordinator
LOG:  skipping missing configuration file "/home/postgres/DATA/pgxl/nodes/coord_slave.1/postgresql.auto.conf"
/home/postgres/DATA/pgxl/nodes/coord_slave.1



________________________________
zhang.eamon at hotmail.com
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-bugs-postgres-xl.org/attachments/20160308/a727d7e8/attachment.htm>


More information about the postgres-xl-bugs mailing list