Vertica Eon Mode from Enterprise Mode
Hi ,
I have Vertica version 9.2 Enterpriose mode and I would like to shift to Eon Mode.
Is there any way I can migrate Enterprise mode to Eon mode. As per vertica documents you cannot directly switch between Enterprise Mode and Eon Mode. You choose the mode for your database when you create it. Once created, you cannot change the database's mode. If you want to use a different mode, you must back up your data, create a new database using the new mode, and then reload your data.
Is there any other way to migrate data from Vertica Enterprise mode to Eon mode.
0
Comments
Apart from what is mentioned in the documentation. There is no way to migrate data from Enterprise to EON mode.
Let me re-frame the questions: How can I migrate from Enterprise Mode to Eon Mode?
I read the documentation it has not been given in detail.
For Example:
Will copy cluster work there? Or Backup Restore? Or Export ?
One way is to export data to S3 from your existing database using s3export function and run COPY from S3 in your EON mode database.
You can can import/export data across databases (i.e. Enterprise to Eon)
See:
https://www.vertica.com/docs/9.2.x/HTML/Content/Authoring/AdministratorsGuide/CopyExportData/CopyingAndExportingData.htm
Thanks SruthiA And Jim.
Any idea on Backup and restore? Since the catalog is large with lot of tables.
Data volume is also huge. Can I do Enterprise backup and restore in EON?
@hdk0310 - Currently you cannot use the vbr utility to take a full backup of a Vertica Enterprise DB and then restore it to Vertica EON DB.
Thanks Jim