The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!

How can I remove a node when the database is currently down?

One of nodes (02) in our four-node development cluster is having its hard drive worked on. It's unavailable and has been wiped. I'd like to bring the database up. However, node 02 was taken out _after_ the database was brought down. I would have thought that I could bring the db up, and the other nodes would recognize that 02 is unavailable, etc. Instead, the db refuses to come up. Is there a way to get around this (tell the system to remove the node, etc) and then bring the db up?

Comments

  • If your system is K-safe 1, the database should come up with a node down.  If you aren't running K=1, then you will have data loss as the data from node 2 is not replicated anywhere else.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file