mosheg
Administrator
mosheg Administrator
Reactions
-
Re: Vertica startup failure due to power cut (ASR required)
-- Try the following but please note that you might lose data -- Start the database in unsafe mode: admintools -t start_db -d YourDBname -p DBpassword -U -- If dfs files missing remove the dfs files:… (View Post)1 -
Re: Vertica startup failure due to power cut (ASR required)
Please try the following: 1) To start the database in unsafe mode: admintools -t start_db -d YourDBname -p DBpassword -U 2) The below query Identify impacted projections: SELECT e.node_name, t.table_… (View Post)2 -
Re: Vertica startup failure due to power cut (ASR required)
As Bryan mentioned it is strongly recommended to contact support for assistance to avoid data loss. Please note that when you start a database from a specific Epoch you might lose data as this can al… (View Post)1 -
Re: Lost Vertica DB password
Vertica support can try to help you. Please open a support case. (View Post)2 -
Re: Prevent specific column value-rows in a Vertica table
In addition, if the "org" field has a wide range of possible values, consider the following example: -- This script is responsible for loading data into the target table only if the "o… (View Post)1