[Postgres-xl-general] Adding new nodes

Aaron Jackson ajackson at revionics.com
Thu Jul 24 08:20:44 PDT 2014


So I got past the error by starting datanode5 and datanode6.  However, it then told me that datanode4 was a duplicate.  Does the "add" command do complete provisioning and if so, how would I go about adding a new datanode that I've created via "init" and "start" as I've outlined?
Aaron
________________________________
From: Aaron Jackson [ajackson at revionics.com]
Sent: Thursday, July 24, 2014 10:16 AM
To: postgres-xl-general at lists.sourceforge.net
Subject: [Postgres-xl-general] Adding new nodes

I have a 3 server cluster - pgs01, pgs02 and pgs03.  I want to expand this cluster by adding 3 new data nodes running on the same hardware (see my MPP question before).  I modified my pgxc_ctl.conf and modified it in the following ways:

  *   Added a secondary datanode directory location of .../pgsql/dn_master_2
  *   Expanded datanodeNames to 6 (datanode1 ... datanode6)
  *   Expanded datanodePorts to (15432 15432 15432 15433 15433 154333)
  *   Expanded datanodePoolerPorts to (15432 15432 15432 15433 15433 15433)
     *   I'm assuming the pooler port can be the same as the node port
  *   Expanded datanodeMasterServers (pgs01 pgs02 pgs03 pgs01 pgs02 pgs03)
  *   Expanded datanodeMasterDirs to 6 directories
  *   Expanded datanodeMaxWALSenders to 6

I left the coordinators alone...

Jumped into pgxc_ctl and initialized all 3 of the new datanodes as follows:

pgxc_ctl init datanode master datanode4
pgxc_ctl init datanode master datanode5
pgxc_ctl init datanode master datanode6

These worked fine.  So I started the first datanode ...

pgxc_ctl start datanode datanode4

Then I attempted to add them to the cluster as follows:

pgxc_ctl add datanode master datanode4 pgs01 15432 15433 /var/lib/pgsql/dn_master_2 none

Came back with an error message that I don't understand ...

ERROR: Some of the coordinator masters are not running. Cannot add new one.

Can anyone help me figure out what I'm missing?  The new datanode is running and is reachable.
Aaron
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/pipermail/postgres-xl-general-postgres-xl.org/attachments/20140724/b3ba3b95/attachment.htm>


More information about the postgres-xl-general mailing list