Search found 221 matches
- 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 ...
- 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?
- 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...
- 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!
- 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.
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.
- 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...
- 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...