Stopping a database that has a pw

Moderator: NorbertKrupa

Post Reply
User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Stopping a database that has a pw

Post by Julie » Wed Jan 28, 2015 3:40 am

Hello,

I am getting an error when trying to use the stop_db tool per the admintools command line:

Code: Select all

[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 password
So I thought I could just use the -w option (i.e. password), but that doesn't work 'cause I get this error:

Code: Select all

[dbadmin@v01 ~]$ admintools -t stop_db -d my_test_db -w password
Usage: stop_db [options]

stop_db: error: no such option: -w
So how the heck do I pass in the password to admintools?
Thanks,
Juliette

User avatar
JimKnicely
Site Admin
Site Admin
Posts: 1822
Joined: Sat Jan 21, 2012 4:58 am
Contact:

Re: Stopping a database that has a pw

Post by JimKnicely » Wed Jan 28, 2015 3:54 am

Hey Julie,

The -w option is for the password in vsql, while -p is used for admintools. You can get this info from the --help option:

Code: Select all

[dbadmin@alf01 ~]$ admintools -t stop_db --help
Usage: stop_db [options]

Options:
  -h, --help            show this help message and exit
  -d DB, --database=DB  Name of database to be stopped
  -p DBPASSWORD, --password=DBPASSWORD
                        Database password in single quotes
  -F, --force           Force the databases to shutdown, even if users are
                        connected.
  -i, --noprompts       do not stop and wait for user input(default false)
Jim Knicely

Image

Note: I work for Vertica. My views, opinions, and thoughts expressed here do not represent those of my employer.

User avatar
Julie
Master
Master
Posts: 221
Joined: Thu Apr 19, 2012 9:29 pm

Re: Stopping a database that has a pw

Post by Julie » Thu Jan 29, 2015 12:11 am

Ahhhhhhhh! Darn, I should have known that! Thanks Jim!
Thanks,
Juliette

Post Reply

Return to “Vertica Administration Tools”