Reverting to initial epoch / Removing history

roger_mooreroger_moore
in General Discussion

Without reinstalling, is there a way I can delete all the data and the history and get back to how the system was when I first installed it (back to the initial epoch) while keeping my current schemas and projections?

Comments

  • Sharon_CutterSharon_Cutter ✭✭

    You can use export_catalog() to export the table and projection definitions, drop the database, recreate the database, and then recreate the tables and projections.  The export_catalog() won't include users or permissions - you would need to recreate those.

     

    You could also write a script to TRUNCATE all of the tables.  TRUNCATE doesn't maintain history.

     

    I recall your database was having some issues with replay delete?  You should also address the projection design issues that were causing that.

     

     

     

     

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...