Copying (Cloning) DB to another Vertica Cluster with Different no. of Nodes and Different IP Addresses

Question

I have this requirement where I have to copy the complete DB from a single node installation to a 2 nodes cluster of Vertica. As per the documentation this is not possible.

Are there no workaround methods for performing this?

We may not always have same no. of nodes in different clusters especially when it is a pre-prod and prod case. So some method must exist for doing this.

Kindly advise on the same.

Answer 1

Unfortunately this not possible at this time.

You can export to another single node, then add a node. As a side note, you want at least 3 nodes for a production environment.

For users, roles and permissions, see datadug.com's export script.

With regards to moving data, you have a few options:

1. EXPORT TO VERTICA - Allows for for export of an entire table, specific columns, or the result of a SELECT
2. COPY FROM VERTICA - Works similiar to EXPORT however does not allow for the result of a SELECT
3. vsql - Import flat files by piping out an input into the output of another vsql command using COPY