We're Moving!

The Vertica Forum is moving to a new OpenText Analytics Database (Vertica) Community.

Join us there to post discussion topics, learn about

product releases, share tips, access the blog, and much more.

Create My New Community Account Now


How to start DataBase from commandline using plink.exe — Vertica Forum

How to start DataBase from commandline using plink.exe

Ajit_NayakAjit_Nayak
in General Discussion
I am now manually opening my vertica database through putty.exe and by specifying the folder path (Admintools) it is showing one window to start/stop/connect to the database etc. I need only to start the database from passing the commandline through plink.exe How can I do this please suggest Thanks Ajit Kumar Nayak

Comments

  • [Deleted User][Deleted User] ✭
    Hi Ajit, You can script many of the admintools options. Check the documentation to see the list of those options, https://my.vertica.com/docs/6.1.x/HTML/index.htm#3824.htm One of the options is to restart_db. Hope this helps, Eugenia
  • Ajit_NayakAjit_Nayak
    Thanks Eugenia Moreno for your reply I am using the following command through plink.exe -ssh -l root -i "C:\xyz.ppk" "/opt/vertica/bin/admintools -t start_db -d DB -p 'password'" But it is showing root user has no permission to do this . As I have a super user dbadmin to do the above opertaion. How can I pass 'su dbadmin' command through plink.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Format
SpoilerCodeQuote
Heading 2Heading 1
Emoji
:):D:(;):/:o:s:p:'(:|B):#:*<3o:)>:)
Url
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file
Home • General DiscussionComment As ...