[Postgres-xl-general] Adding new datanode and "ALTER TABLE REDISTRIBUTE"

Dennis dennisr at visi.com
Tue Sep 16 10:27:52 PDT 2014

Hi all,   I am confused by the current documentation.  I have just added new datanode to my cluster and now I need to redistribute the tables to the new node.  The documentation says I need to "Redistribute existing data by using ALTER TABLE REDISTRIBUTE. The new datanode is now ready.”  (From: http://files.postgres-xl.org/documentation/add-node-datanode.html)

But there doesn’t seem to be a “ATLER TABLE REDISTRIBUTE” command.  So I am wondering if the correct command is to issue an “ALTER TABLE foo ADD NODE(new_node);” command and if that will redistribute the table and it’s indexes.  I am using both replicated and round robin distribution schemes currently.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.postgres-xl.org/private.cgi/postgres-xl-general-postgres-xl.org/attachments/20140916/b16ee99d/attachment.htm>

More information about the postgres-xl-general mailing list