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?
Reverting to initial epoch / Removing history
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.
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
