create db with a different ksafe

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

R_McKeon

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