Redistributing Configuration Files to Nodes

The add and remove node processes automatically redistribute the Vertica configuration files. You rarely need to redistribute the configuration files to help resolve configuration issues.

To distribute configuration files to a host:

  1. Log on to a host that contains these files and start the Administration Tools.

    See Using the Administration Tools for information about accessing the Administration Tools.

  2. On the Main Menu in the Administration Tools, select Configuration Menu and click OK.
  3. On the Configuration Menu, select Distribute Config Files and click OK.
  4. Select Database Configuration.

  5. Select the database where you want to distribute the files and click OK.

    The vertica.conf file is distributed to all the other hosts in the database. If it previously existed on a host, it is overwritten.

  6. On the Configuration Menu, select Distribute Config Files and click OK.

  7. Select SSL Keys.

    The certifications and keys for the host are distributed to all the other hosts in the database. If they previously existed on a host, they are overwritten.

  8. On the Configuration Menu, select Distribute Config Files and click OK.

    Select AdminTools Meta-Data.

    The Administration Tools metadata is distributed to every host in the cluster.

  9. Restart the database.

To distribute configuration files from the command line or via scripts, use the admintools option distribute_config_files:

admintools -t distribute_config_files