RELOAD_SPREAD

Updates cluster changes to the catalog's Spread configuration file. These changes include:

  • New or realigned control nodes
  • New Spread hosts or fault group
  • New or dropped cluster nodes

This function is often used in a multi-step process for large and elastic cluster arrangements. Calling it might require you to restart the database. You must then rebalance the cluster to realize fault tolerance. For details, see Defining and Realigning Control Nodes in the Administrator's Guide.

In an Eon Mode database, using this function could result in a database shutdown. Nodes may become disconnected after you call this function. If the database no longer has full shard coverage without these nodes, it shuts down to maintain data integrity. You can safely restart a database that shuts down after calling this function, as the disconnected nodes will rejoin the database on startup.

Syntax

RELOAD_SPREAD( true )

Parameters

true

Updates cluster changes related to control message responsibilities to the Spread configuration file.

Privileges

Superuser

Example

Update the cluster with changes to control messaging:

=> SELECT reload_spread(true);
 reload_spread
---------------
 reloaded
(1 row)

See Also

REBALANCE_CLUSTER