Search found 221 matches

by Julie
Wed Jan 28, 2015 3:40 am
Forum: Vertica Administration Tools
Topic: Stopping a database that has a pw
Replies: 2
Views: 16303

Stopping a database that has a pw

Hello, I am getting an error when trying to use the stop_db tool per the admintools command line: [dbadmin@v01 ~]$ admintools -t stop_db -d my_test_db Info: no password specified, using none Issuing shutdown command to database Database my_test_db not stopped successfully Error: Invalid username or ...
by Julie
Sat Dec 06, 2014 6:04 pm
Forum: New to Vertica Database Administration
Topic: The adminTools-dbadmin.errors file
Replies: 2
Views: 6558

Re: The adminTools-dbadmin.errors file

id10t, thanks for looking into this! Did the error you generated appear in your /opt/vertica/log/adminTools-dbadmin.log file?
by Julie
Sat Dec 06, 2014 3:37 pm
Forum: New to Vertica Database Administration
Topic: The adminTools-dbadmin.errors file
Replies: 2
Views: 6558

The adminTools-dbadmin.errors file

Hi all, Somebody on this site always knows the answers to my stupid question. Typically it is sKwa :) Anyway, here's a new question.... I would assume that the file /opt/vertica/log/adminTools-dbadmin.errors would contain entries detailing any errors that may have occurred when using the Admin Tools...
by Julie
Sat Dec 06, 2014 3:32 pm
Forum: New to Vertica Database Administration
Topic: Change location of adminTools-dbadmin.log file?
Replies: 2
Views: 7282

Re: Change location of adminTools-dbadmin.log file?

Thanks for the quick response and explanation!
by Julie
Fri Dec 05, 2014 10:23 pm
Forum: New to Vertica Database Administration
Topic: Change location of adminTools-dbadmin.log file?
Replies: 2
Views: 7282

Change location of adminTools-dbadmin.log file?

Hi guys,

Is it possible to change where the adminTools-dbadmin.log is kept? By default it is here /opt/vertica/log... I'm just curious, actually.

Thank you.
by Julie
Tue Nov 04, 2014 2:16 pm
Forum: Vertica Database Administration
Topic: Characteristics of Default Automatic Projections (Encoding)
Replies: 1
Views: 5046

Characteristics of Default Automatic Projections (Encoding)

Hi, From the admin doc, it says one of the characteristics of default automatic projections is that "If created as a result of a CREATE TABLE AS SELECT statement, uses the encoding specified in the query table." However, in practice, this does not seem to be the case. dbadmin=> create table public.t...
by Julie
Tue Oct 28, 2014 4:00 pm
Forum: Vertica Database Administration
Topic: Odd or Even Number of Nodes
Replies: 3
Views: 8941

Re: Odd or Even Number of Nodes

Isn't it true that having an even number of nodes does not give you better HA than the even number of nodes minus 1? That is, if a database has a k-safety of 1 and if you have 6 nodes the HA isn't any better than having 5 nodes? In either case you can lose two nodes, but if you lose three the databa...

Go to advanced search