Skip to main content

Vertica Eon Mode from Enterprise Mode

  • February 25, 2019
  • 7 replies
  • 11 views
hdk0310
Forum|alt.badge.img+1

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.

    7 replies

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • February 25, 2019

    Apart from what is mentioned in the documentation. There is no way to migrate data from Enterprise to EON mode.

    hdk0310
    Forum|alt.badge.img+1
    • hdk0310
    • Author
    • Participating Frequently
    • February 26, 2019

    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 ?

    SruthiA
    Forum|alt.badge.img+1
    • SruthiA
    • Participating Frequently
    • February 26, 2019

    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.

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • February 26, 2019

    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

    hdk0310
    Forum|alt.badge.img+1
    • hdk0310
    • Author
    • Participating Frequently
    • February 27, 2019

    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?

    Jim_Knicely
    Forum|alt.badge.img+2
    • Jim_Knicely
    • Participating Frequently
    • February 27, 2019

    @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.

    hdk0310
    Forum|alt.badge.img+1
    • hdk0310
    • Author
    • Participating Frequently
    • February 28, 2019

    Thanks Jim

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement