Skip to main content

create db with a different ksafe

  • March 4, 2014
  • 1 reply
  • 8 views
mario_lanzolla
Hi,
with 3 nodes (or more) cluster, I would like to create a DB with a ksafe=0 just for testing purpose.
How is it possible? As default Vertica creates the db with k-safe=1.

Or, is it possible to change it after the creation, at DB or Schema level?

Thanks

    1 reply

    R_McKeon
    Forum|alt.badge.img
    • R_McKeon
    • Participating Frequently
    • March 4, 2014
    Hello Mario,

    You can set the K-Safety to 0 by running the following command:

    SELECT MARK_DESIGN_KSAFE(0);

    Additional information regarding K-Safety can be found at:

    https://my.vertica.com/docs/6.1.x/HTML/index.htm#4865.htm

    Still scrolling?
    Ask a question
    Terms & ConditionsAccessibility statement